Define a Database Procedure
You can include in a Vision application a procedure composed of SQL statements stored in the database. You use the SQL create procedure statement to create the procedure before you define it in Vision.
See the SQL Reference Guide for more information about creating database procedures. You cannot use an SQL database procedure if you are accessing a non-Ingres database through an Enterprise Access product (formerly Gateway).
To define a database procedure
1. Follow Steps 1 through 8 in Create a New Frame. Specify "DB Proc" as the type.
Vision redisplays the Application Flow Diagram with the new database procedure inserted.
2. Select MoreInfo to display the MoreInfo About a Database Procedure Window, as shown in the following figure.
The window displays the procedure name and description you just entered, as well as when and by whom the frame was created. When the window is displayed, the cursor is on the Return Type field.
3. Specify in one of the following ways the return type of the value that this procedure returns:
• Press Tab to accept the default of "integer."
• Enter a standard Ingres data type or a record type that you have created for this application and press Tab.
• Enter none to indicate no return value and press Tab.
The cursor moves to the Nullable field. The default value of "no" indicates that this procedure cannot return a null value.
4. Press Tab to accept the default, or type yes and press Tab to permit a nullable return value.
5. Change the descriptive Short Remark that you entered when you created the procedure in Vision.
6. When you are done, select End to return to the Application Flow Diagram.
Last modified date: 11/09/2022