SQL - SYSIBM.SYSDBRM - 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.SYSDBRM
Contains one row for each DBRM of each application plan.

Nome da coluna Tipo do dado Descrição Uso
 NAME  CHAR(8) NOT NULL  Name of the DBRM.  G
 TIMESTAMP  CHAR(8) NOT NULL
 FOR BIT DATA
 Consistency token.  G
 PDSNAME  CHAR(44) NOT NULL  Name of the partitioned data set of which the DBRM is a member.  G
 PLNAME  CHAR(8) NOT NULL  Name of the application plan of which this DBRM is a part.  G
 PLCREATOR  CHAR(8) NOT NULL  Authorization ID of the owner of the application plan.  G
 PRECOMPTIME  CHAR(8) NOT NULL  Time of precompilation in the form hhmmssth.

 If the LEVEL precompiler option is used, then this value does not represent the  precompile time.
 G
 PRECOMPDATE  CHAR(6) NOT NULL  Date of precompilation in the form yymmdd.

 If the LEVEL precompiler option is used, then this value does not represent the  precompile date.
 G
 QUOTE  CHAR(1) NOT NULL  SQL string delimiter for the SQL statements in the DBRM:

 N      Apostrophe
 Y      Quotation mark
 G
 COMMA  CHAR(1) NOT NULL  Decimal point representation for SQL statements in the DBRM:

 N      Period
 Y      Comma
 G
 HOSTLANG  CHAR(1) NOT NULL  The host language used:

 B      Assembler language
 C      OS/VS COBOL
 D      C
 F      FORTRAN
 P      PL/I
 2      VS COBOL II or IBM COBOL Release 1 (formerly called COBOL/370)
 3      IBM COBOL (Release 2 or subsequent releases)
 4      C++
 G
 IBMREQD  CHAR(1) NOT NULL  Whether the row came from the basic machine-readable material (MRM) tape:

 N      No
 Y      Yes
 G
 CHARSET  CHAR(1) NOT NULL
 WITH DEFAULT
 Indicates whether the system CCSID for SBCS data was 290 (Katakana) when the  program was precompiled.

 A      No
 K      Yes
 G
 MIXED  CHAR(1) NOT NULL
 WITH DEFAULT
 Indicates if mixed data was in effect when the application program was precompiled  (for more on when mixed data is in effect, see "Character Strings" in topic 3.7.1):

 N      No
 Y      Yes
 G
 DEC31  CHAR(1) NOT NULL
 WITH DEFAULT
 Indicates whether DEC31 was in effect when the program was precompiled (for more  on when DEC31 is in effect, see "Arithmetic with Two Decimal Operands" in topic  3.14.6):

 blank      No
 Y             Yes
 G
 VERSION  CHAR(64) NOT NULL
 WITH DEFAULT
 Version identifier for the DBRM.  G
 PRECOMPTS  TIMESTAMP NOT NULL
 WITH DEFAULT
 Time when the DBRM was precompiled.  G


© Copyright IBM Corp.