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

5 Creating SPJs in a Neoview Database
This chapter describes how to create SPJs in a Neoview database after you have moved the SPJ
JAR files to the Neoview platform. To create or drop SPJs from a Neoview database, you must
have the Neoview DB Admin tool.
• “Required Privileges for Creating an SPJ”
• “Creating SPJs”
• “Displaying the SPJs in a Schema” (page 47)
• “Dropping SPJs” (page 49)
• “Altering an SPJ and Its Java Bytecode” (page 50)
Required Privileges for Creating an SPJ
To create an SPJ in a schema, your user role must be the schema owner.
Creating SPJs
1. In DB Admin, click the Database tab.
2. Open the Schemas folder, and navigate to the schema where you want to create the SPJ.
3. Right-click the schema folder and then select Create Procedure (or click the schema folder
and then click the Create Procedure link in the right pane):
The Create Procedure Wizard launches.
4. On the Name page of the Create Procedure Wizard, enter a name for the stored procedure:
Required Privileges for Creating an SPJ 43