SQL - SYSIBM.SYSPKSYSTEM - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SYSIBM.SYSPKSYSTEM
Contains zero or more rows for every package.
Each row for a given package represents one or more connections to an environment in which the package could be executed.

Nome da coluna Tipo de dados Descrição Uso
 LOCATION  CHAR(16) NOT NULL  Always contains blanks S
 COLLID  CHAR(18) NOT NULL  Name of the package collection. G
 NAME  CHAR(8) NOT NULL  Name of the package. G
 CONTOKEN  CHAR(8) NOT NULL  Consistency token for the package. This is either:

 ° The "level" as specified by the LEVEL option when the package's     program was precompiled
 ° The timestamp indicating when the package's program was     precompiled, in an internal format.
S
 SYSTEM  CHAR(8) NOT NULL  Environment. Values can be:

 BATCH TSO batch
 CICS Customer Information Control System
 DB2CALL DB2 call attachment facility
 DLIBATCH DLI batch support facility
 IMSBMP IMS BMP region
 IMSMPP IMS MPP and IFP region
 REMOTE remote application server
G
 ENABLE  CHAR(1) NOT NULL  Indicates whether the connections represented by the row are enabled  or disabled:

 N    Disabled
 Y    Enabled
G
 CNAME  CHAR(20) NOT NULL  Identifies the connection or connections to which the row applies.  Interpretation depends on the environment specified by SYSTEM.
 Values can be:

 ° Blank if SYSTEM=BATCH or SYSTEM=DB2CALL

 ° The LU name for an application server if SYSTEM=REMOTE

 ° Either the requester's location (if the product is DB2) or the requester's    LU name enclosed in angle brackets if SYSTEM=REMOTE.

 ° The name of a single connection if SYSTEM has any other value.

 CNAME can also be blank when SYSTEM is not equal to BATCH or  DB2CALL. When this is so, the row applies to all servers or connections  for the indicated environment.
G
 IBMREQD  CHAR(1) NOT NULL  Whether the row came from the basic machine readable material(MRM)  tape:

 N    No
 Y    Yes
G


© Copyright IBM Corp.