SQL - SYSIBM.SYSPLSYSTEM - 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.SYSPLSYSTEM
Contains zero or more rows for every plan.
Each row for a given plan represents one or more connections to an environment in which the plan could be used.

Nome da coluna Tipo de dados Descrição Uso
 NAME  CHAR(8) NOT NULL  Name of the plan G
 SYSTEM  CHAR(8) NOT NULL  Environment. Values can be:

 BATCH        TSO batch
 DB2CALL     DB2 call attachment facility
 CICS           Customer Information Control System
 DLIBATCH   DLI batch support facility
 IMSBMP      IMS BMP region
 IMSMPP      IMS MPP or IFP region		 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(8) 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 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 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.