Use the Procedures page of the SQL Assist SmartGuide for Stored Procedures to specify the stored procedure that is executed in an SQL CALL statement.
Each stored procedure you can access in the database identified by the currently selected connection alias is listed in a row of the table on this page.
By default, the stored procedures listed are those whose schema is the user ID specified for the database connection. If no procedures in the database have that schema, all the procedures in the database are listed.
You can add to or remove from the stored procedure names displayed in the list, by selecting View schema(s).
Selecting View schema(s) opens the Schema(s) to View window.
When you finish selecting schemas to view, select OK. This closes the Schema(s) to View window.
Select a stored procedure for the SQL CALL statement by clicking on the row for that stored procedure. You can select only one stored procedure.
When you finish, select Next. This displays the Parameters page of the SQL Assist SmartGuide for Stored Procedures. Use this page to work with the parameters for the selected stored procedure. You can also display any page in the SQL Assist SmartGuide for Stored Procedures by selecting its tab.
When you complete the specification of your SQL CALL statement, select Finish. This generates the code for the SQL statement and closes the SQL Assist SmartGuide for Stored Procedures.
To cancel visual composition of the SQL CALL statement, select Cancel.
Working with stored procedure parameters
Defining result sets returned by a stored procedure
Displaying the SQL statement for a ProcedureCall bean