IBM DB2 User Manual

the value of the SECURITY parameter determines the authorization ID that
must have authority to access z/OS UNIX System Services. The values of
SECURITY and the IDs that must have access to z/OS UNIX System Services
are:
DB2 The user ID that is defined for the stored procedure address space in
the RACF started-procedure table.
EXTERNAL
The invoker of the routine.
DEFINER
The definer of the routine.
ALLOW DEBUG MODE, DISALLOW DEBUG MODE, or DISABLE DEBUG
MODE
Specifies whether a Java stored procedure can be run in debugging mode.
When DYNAMICRULES run behavior is in effect, the default is determined by
using the value of the CURRENT DEBUG MODE special register. Otherwise
the default is DISALLOW DEBUG MODE.
ALLOW DEBUG MODE
Specifies that the procedure can be run in debugging mode.
DISALLOW DEBUG MODE
Specifies that the procedure cannot be run in debugging mode.
You can use an ALTER PROCEDURE statement to change this option to
ALLOW DEBUG MODE.
DISABLE DEBUG MODE
Specifies that the procedure can never be run in debugging mode.
The procedure cannot be changed to specify ALLOW DEBUG MODE or
DISALLOW DEBUG MODE once the procedure has been created or altered
using DISABLE DEBUG MODE. To change this option, you must drop and
recreate the procedure using the desired option.
Example: Defining a Java stored procedure: Suppose that you have written and
prepared a stored procedure that has these characteristics:
Fully-qualified procedure name SYSPROC.S1SAL
Parameters DECIMAL(10,2) INOUT
Language Java
Collection ID for the stored procedure
package
DSNJDBC
Package, class, and method name s1.S1Sal.getSals
Type of SQL statements in the program Statements that modify DB2 tables
WLM environment name WLMIJAV
Maximum number of result sets returned 1
This CREATE PROCEDURE statement defines the stored procedure to DB2:
CREATE PROCEDURE SYSPROC.S1SAL
(DECIMAL(10,2) INOUT)
FENCED
MODIFIES SQL DATA
COLLID DSNJDBC
LANGUAGE JAVA
EXTERNAL NAME 's1.S1Sal.getSals'
Chapter 5. Java stored procedures and user-defined functions 167
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|

IBM DB2 Specifications

General

Developer	IBM
Initial Release	1983
License	Proprietary
Written in	C, C++
Category	Database Management System (RDBMS)
Operating System	Linux, Windows
Programming Languages	C, C++
Data Models	Relational
Editions	Community, Standard, Advanced
Key Features	high availability, scalability