Managing Stored Procedures

If a data type has been defined in the Global parameters, user input will be validated in both Manage Stored Procedures and Execute Stored Procedures dialog boxes.

To manage a stored procedure:

1. In the Data Models and Views tab, right-click a Data Model and select Manage Stored Procedures.

   

2. Enter a name for the stored procedure.

3. On the right pane, click on the field you want to add and choose the value you want to use in order to define the procedure.
   

   

   Note

   The @USER parameter is added automatically, so you should take it into account for your stored procedure even if you do not want to use it in your SELECT or UPDATE or INSERT statement.

4. Click Confirm to finish.

To execute a stored procedure:

1. In the Data Models and Views tab, right-click a Data Model and select Execute Stored Procedures.

   

2. The Execute Stored Procedure dialog box is displayed. Click Confirm.

   

   Note

   The @@CURDATE value we selected in the stored procedure called MyStoredProcedure has been automatically translated in the format YYYY-MM-DD (here it is 2019/08/29).

   The result in an SQL Table will look like this: