Use the SQL page of the SQL Assist SmartGuide for Stored Procedures to display the SQL statement for a ProcedureCall bean.
Schema qualified name
The schema qualified name checkbox allows you to qualify the stored procedure name with its schema name by selecting it. If you have described result sets that the stored procedure returns, selecting this checkbox also causes table names in the generated meta-data to be qualified with their schema names. At runtime, you can use the same database and user ID you used to specify the CALL statement, or another database and/or user ID. If the Schema qualified name checkbox is selected, the stored procedure and tables must be defined on the database where the statement executes, with the same schemas you specified. If the checkbox is not selected, the stored procedure and tables must be defined on the database where the statement executes, with a schema that matches the user ID you use to connect.
You can edit any part of the SQL specification by selecting the appropriate page in the SQL Assist SmartGuide for Stored Procedures. Selecting Back displays the last Result page. If appropriate, you can use this page to re-specify the result set.
If the specification of your SQL statement is complete, select Finish. This generates the code for the SQL statement and closes the SQLAssist SmartGuide for Stored Procedures.
To cancel the visual composition of the SQL CALL statement, select Cancel.
Specifying the stored procedure for an SQL CALL statement
Working with stored procedure parameters
Defining result sets returned by a stored procedure