Neoview Guide to Stored Procedures in Java (R2.2)

including 255. The actual number of result sets returned by the SPJ method can be less
than or equal to this number.
• If your SPJ method performs any SQL operations, select the Accesses Database check
box.
IMPORTANT: If you do not select the Accesses Database check box and your SPJ
method performs SQL operations, Neoview SQL returns an error when trying to execute
the procedure.
8. Click Finish to create the procedure.
9. When prompted to create the procedure in the schema, click Yes to continue or No to quit
the operation.
Displaying the SPJs in a Schema
To display the SPJs in a schema, either use the Neoview DB Admin tool or Neoview Script:
• “Using DB Admin to Display SPJs in a Schema”
• “Using Neoview Script to Display SPJs in a Schema” (page 49)
Using DB Admin to Display SPJs in a Schema
1. In DB Admin, click the Database tab.
2. Open the Schemas folder, and navigate to the schema that contains the SPJs.
3. Open the schema folder, and then open the Procedures folder.
4. See the list of procedures in the right pane:
5. To display detailed information about each procedure, click the procedure name under the
Procedures folder, or click the procedure name link in the right pane.
6. Click the Parameters tab to display the parameters of the SPJ:
Displaying the SPJs in a Schema 47