HP Neoview Release 2.5 Software - Manual (Page 168)

Action Control or Field Group Box
Controls the maximum number of result sets the procedure can return. This
control is enabled only if the method signature contains a java.sql.ResultSet[]
object. If the method contains a result set object, the valid range is 1 to 255.
This value is automatically set to zero if the selected Java method does not
have a java.sql.ResultSet[] object. Number of dynamic
result sets Attributes
If selected, the procedure performs SQL operations. If cleared, the procedure
does not perform SQL operations.
NOTE: Neoview SQL returns an error if this attribute is cleared and the
procedure performs SQL operations.
Accesses Database
Related Topics
“Create a Procedure” (page 165)
Use a Method in a Procedure
To be used in a procedure, a Java method must:
• Be qualified as public static void.
• Have a java.sql.ResultSet[] parameter at the end of the method signature if the method uses
result sets.
NOTE: There can be more than one java.sql.ResultSet[] parameter, but they must all be at
the end of the method signature.
• Have these parameter types:
Type
Parameter Type
or Class
“java.lang.String” character
“java.lang.String[]”
“java.lang.Integer” numeric
“java.lang.Integer[]”
“java.lang.Long”
“java.lang.Long[]”
“java.lang.Float”
“java.lang.Float[]”
“java.lang.Double”
“java.lang.Double[]”
“java.math.BigDecimal”
“java.math.BigDecimal[]”
“java.sql.Date” date/timestamp
“java.sql.Date[]”
“java.sql.Time”
“java.sql.Time[]”
“java.sql.Timestamp”
“java.sql.Timestamp[]”
168 Manage Procedures