|
SYSIBM.SYSPROCEDURES www.cadcobol.com - linguagem de programação COBOL |
|
|
|
|
| Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. |
Contains one row for every stored procedure. Rows in this table must be inserted, updated, and deleted; they are not automatically inserted and maintained by DB2.
One method of adding rows to this table is by using the LOAD utility.
| 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 |