Hi Everyone,

Here’s the 2nd post of the series, #HowToWithAprisoMI,  which is - “Execution of Stored Procedure via MI Script”.

As part of this post, we are going to do the following things:

1. Execution of a custom Stored Procedure – “AP_EmployeeInfo” via MI Script
   • This Stored Procedure takes “Employee No” as an input
   • And returns Employee’s “ID” and “Given Name” against the provided Emp. No.
2. “EmployeeNo” to the above SP will be passed as a user input
   • In this case, we will provide it from an OPC client
3. Eventually, we will set the outputs of the SP to OPC tags
   • Outputs are: Employee ID and Employee’s Given Name

Following is the URL of the earlier post:

https://r1132100503382-eu1-3dswym.3dexperience.3ds.com/#community:44/post:nH-hKgIASpWf6ACMQWjneQ