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

NOTE: The left pane of the Procedure Code File Bro wser shows folders for your Neoview

role and private user ID. If you select the role folder, the Procedure Code File Browser

shows all of the JAR files for the Neoview role that you used to connect to the current system.

The role is your default role unless you specified a different role in the system definition.

If an SPJ JAR file does not exist on the Neoview platform, you can upload it. See “Upload

a JAR File” (page 33).

6. In the Parameters group box, verify that the SQL parameters are mapped correctly to the

Java parameters of the SPJ method.

NOTE: The result set parameters (java.sql.ResultSet[]) in the Java signature do not

have corresponding SQL parameters.

a. To change an SQL parameter, such as the name of the parameter, the SQL data type,

or the parameter mode (direction) select the parameter and click [ Edit ]. The Edit

Parameter dialog box appears.

b. In the Edit Parameter dialog box, enter a new name for the parameter, select a different

SQL data type, if permitted, or select a different parameter mode (direction), if permitted.

When changing the parameter name, note that the parameter name:

• Is not case-sensitive

• Must not be a reserved word

• Must not contain spaces

• Must begin with a letter, digit, or underscore

When changing the SQL data type, select a data type that is appropriate for the parameter

of the underlying Java method. For information about SQL data types, see the Neoview

SQL Reference Manual.

For character string parameters, select either ISO88591 or UCS2 depending on the

column definition and the character set configuration of your Neoview platform. For

guidelines, see the Neoview Character Sets Administrator's Guide.

c. Click [ OK ] to accept the changes, or click [ Cancel ] to quit the Edit Parameter dialog

box.

d. Repeat steps a to c for each parameter that you want to change.

7. In the Attributes group box, if your SPJ method returns result sets, enter the maximum

number of result sets to be returned for Number of dynamic result sets. The valid range

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.