| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| PROCEDURE |
CHAR(18) NOT NULL |
The name of the stored procedure specified on the SQL CALL statement. |
G |
| AUTHID |
CHAR(8) NOT NULL
WITH DEFAULT |
The SQL authorization ID of the user running the SQL application that
issued the SQL CALL statement. When the SQL CALL statement is
received from a remote location, this column is compared to the value of
the authorization ID after outbound and inbound name translation
operations have been performed.
If AUTHID is blank, values in this row apply to all authorization IDs. |
G |
| LUNAME |
CHAR(8) NOT NULL
WITH DEFAULT |
The LUNAME of the system that issued the SQL CALL statement.
° If the LUNAME column contains the local DB2 system's LUNAME, this
row applies to local applications that issue the SQL CALL statement.
° If the LUNAME column contains the LUNAME of a remote client, this row
applies to SQL CALL statements received from that remote client.
° If LUNAME is blank, the values in this row apply to all systems,
including the local DB2 system and clients connected through TCP/IP or
SNA.
To ease migration to future releases of DB2, specify blanks in this field. |
G |
| LOADMOD |
CHAR(8) NOT NULL |
The program that runs when the CALL statement is executed.
When the value of LANGUAGE is COMPJAVA, this column value is not
used. |
G |
| LINKAGE |
CHAR(1) NOT NULL
WITJ DEFAULT |
The linkage convention used to pass parameters to the stored procedure:
blank The SIMPLE linkage convention is used where input parameters
cannot be null.
N
The SIMPLE WITH NULLS convention is used where an indicator
array is passed to the stored procedure. Null input parameters
are allowed.
This value must be N when the value of LANGUAGE is COMPJAVA.
Conventions for passing parameters to stored procedures are described
in Section 6 of Application Programmingand SQL Guide |
G |
| COLLID |
CHAR(18) NOT NULL |
The name of the package collection to use when the stored procedure is
executed.
A blank value indicates that the package collection is the same as the
package collection of the program that issued the SQL CALL statement. |
G |
| LANGUAGE |
CHAR(8) NOT NULL |
The programming language used to create the stored procedure.
Possible values are 'ASSEMBLE', 'PLI', 'COBOL', 'C', 'REXX', or
'COMPJAVA'. |
G |
| ASUTIME |
INTEGER NOT NULL
WITH DEFAULT |
The number of service units permitted for any single invocation of this
stored procedure. If ASUTIME is zero, there is no limit on the service
units.
If a stored procedure uses more service units than allowed by the
ASUTIME value, DB2 cancels the stored procedure. |
G |
| STAYRESIDENT |
CHAR(1) NOT NULL
WITJ DEFAULT |
Determines whether the stored procedure load module is deleted from
memory when the stored procedure ends.
Y
The load module remains resident in memory after the stored
procedure ends.
blank The load module is deleted from memory after the stored
procedure ends. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
Indicates whether the row came from the basic machine readable
material (MRM) tape:
N No
Y Yes |
G |
| RUNOPTS |
VARCHAR(254) NOT NULL |
The Language Environment (Language Environment for MVS & VM)
run-time options to use for this stored procedure. For a REXX stored
procedure, this value is the Language Environment run-time options for
the REXX interface to DB2. If this column contains an empty string, the
installation default Language Environment run-time options are used.
An example Language Environment run-time option list follows:
'MSGFILE(OUTFILE),RPTSTG(ON),RPTOPTS(ON)'
When the value of LANGUAGE is COMPJAVA, this column value is the
stored procedure program name, in the format class.method or
package.class.method. |
G |
| PARMLIST |
VARCHAR(3000) NOT NULL |
Defines the parameter list expected by the stored procedure. For syntax
and a description of the information contained in the PARMLIST string,
see Section 6 of Application Programming and SQL Guide |
G |
| RESULT_SETS |
SMALLINT NOT NULL
WITH DEFAULT |
The maximum number of query result sets that can be returned by this
stored procedure.
Zero indicates there are no query result sets. |
G |
| WLM_ENV |
CHAR(18) NOT NULL
WITH DEFAULT |
The name of the WLM environment to be used to run this stored
procedure.
A blank value results in the stored procedure being run in the
DB2-established stored procedures address space.
For a REXX or COMPJAVA stored procedure, this value must be
non-blank. |
G |
| PGM_TYPE |
CHAR(1) NOT NULL
WITH DEFAULT 'M' |
Whether the stored procedure runs as a main routine or a subroutine.
M The stored procedure runs as a main routine.
S The stored procedure runs as a subroutine.
For a REXX stored procedure, this value is ignored. |
G |
| EXTERNAL_SECURITY |
CHAR(1) NOT NULL
WITH DEFAULT 'N' |
Whether a special RACF environment is required to control access to
non-SQL resources.
N RACF access to non-SQL resources is not required for the stored
procedure. This option is sufficient when the stored procedure only
accesses SQL objects.
Y A RACF environment should be automatically created by DB2 each
time the stored procedure is invoked so thatRACF can manage
access to non-SQL resources. |
G |
| COMMIT_ON_RETURN |
CHAR(1)
WITH DEFAULT 'N' |
Indicates that the unit of work is always to be committed immediately
upon successful return (non-negative SQLCODE) from this stored
procedure.
N The unit of work is to continue.
Y The unit of work is to be committed.
A null value means the same as the value N.
|
G |
