HP Neoview Release 2.5 Software - Manual (Page 167)

is 1 to 255 inclusive. The actual number of result sets returned by the SPJ method can be less
than or equal to this number.
NOTE: The Number of dynamic result sets control is enabled only if the method signature
contains a java.sql.ResultSet[] object.
8. If your SPJ method performs any SQL operations, select the Accesses Database option.
NOTE: If you do not select the Accesses Database option and your SPJ method performs
SQL operations, Neoview SQL returns an error when trying to execute the procedure.
9. Click [ Create ] to create the procedure.
Related Topics
“Use the Create Procedure Dialog Box” (page 167)
Use the Create Procedure Dialog Box
This table shows reference information for the Create Procedure dialog box:
Action Control or Field Group Box
Enter a name for the new procedure. The name must be unique and must
not exist for any procedure, table, or view in the same schema. The procedure
name is not case-sensitive. Neoview SQL automatically qualifies the
procedure name with the name of the schema in which you are creating the
procedure. For example, if you enter monthlyorders as the procedure name,
Neoview SQL stores the procedure as schema-name.MONTHLYORDERS. Name Name
Click [ Browse ] to navigate to a .jar file.
NOTE: Only .jar files that you have uploaded or .jar files that have been
uploaded by members of the Neoview role to which you belong are visible
to you.
Code File Code
Select a class. Class Name
When you select a class, the method names and parameter types for that
class appear in the right pane.
NOTE: Only methods that can be used in a procedure are visible. For
details, see “Use a Method in a Procedure” (page 168) .
Method Name
Is the name for this Neoview SQL parameter. Name Parameters
• IN — passes data to a procedure
• INOUT — passes data to and accepts data from a procedure. The
parameter must be an array.
• OUT — accepts data from a procedure. The parameter must be an array.
Direction
Displays the Neoview SQL data type that is the best match for the Java
signature in the Java Data Type column. SQL Data Type
Displays the signature for the Java method that you selected. Java Data Type
Click to edit the selected parameter. [ Edit ]
Use the Create Procedure Dialog Box 167