Neoview Guide to Stored Procedures in Java (R2.3, R2.4)

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 NCI:
• “Using DB Admin to Display SPJs in a Schema”
• “Using NCI 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