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

b. In the Specify 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 more information, see Table 3-1 (page 26). 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 Neoview 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 Specify Parameter dialog
box.
d. Repeat steps a to c for each parameter that you want to change.
7. Click Attributes. The Attributes page appears:
• If your SPJ method returns result sets, enter the maximum number of result sets to be
returned for Dynamic result sets. The maximum number can be zero up to and
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.
46 Creating SPJs in a Neoview Database