has one input parameter of type INTEGER and returns one result set. The Java
method for the stored procedure receives one parameter of type
java.lang.Integer, but the default Java data type for an SQL type of INTEGER is
int, so the EXTERNAL NAME clause requires a signature clause. The
EXTERNAL NAME parameter is :
EXTERNAL NAME 'sal_JAR:S1Sal.getSals(java.lang.Integer,java.sql.ResultSet[])'
NO SQL
Indicates that the routine does not contain any SQL statements.
For a Java routine that is stored in a JAR file, you cannot specify NO SQL.
PARAMETER STYLE
Identifies the linkage convention that is used to pass parameters to the routine.
For a Java routine, the only value that is valid is PARAMETER STYLE JAVA.
You cannot specify PARAMETER STYLE JAVA for a user-defined table
function.
WLM ENVIRONMENT
Identifies the MVS workload manager (WLM) environment in which the
routine is to run.
If you do not specify this parameter, the routine runs in the default WLM
environment that was specified when DB2 was installed.
PROGRAM TYPE
Specifies whether Language Environment runs the routine as a main routine or
a subroutine.
This parameter value must be PROGRAM TYPE SUB.
RUN OPTIONS
Specifies the Language Environment run-time options to be used for the
routine.
This parameter has no meaning for a Java routine. If you specify this
parameter with LANGUAGE JAVA, DB2 issues an error.
SCRATCHPAD
Specifies that when the user-defined function is invoked for the first time, DB2
allocates memory for a scratchpad.
You cannot use a scratchpad in a Java user-defined function. Do not specify
SCRATCHPAD when you create or alter a Java user-defined function.
FINAL CALL
Specifies that a final call is made to the user-defined function, which the
function can use to free any system resources that it has acquired.
You cannot perform a final call when you call a Java user-defined function. Do
not specify FINAL CALL when you create or alter a Java user-defined function.
DBINFO
Specifies that when the routine is invoked, an additional argument is passed
that contains environment information.
You cannot pass the additional argument when you call a Java routine. Do not
specify DBINFO when you call a Java routine.
SECURITY
Specifies how the routine interacts with an external security product, such as
RACF, to control access to non-SQL resources. The values of the SECURITY
parameter are the same for a Java routine as for any other routine. However,
166 Application Programming Guide and Reference for Java
™
To Next Page
Loading...
Need help?
General