CA IDMS/DB SQL Dictionary Reports—QREPORTS › QREPORT 002 -Table and Column Report › Job Submission

Job Submission

The following syntax will produce an SQL Table Report for the SYSTEM.COLUMN table that resides in dictionary TSTDICT.

DATABASE DICTNAME=dictionary-name
USE "QRPT002"  WITH VALUES (REQUESTED_DICTIONARY='TSTDICT'
                            REQUESTED_SCHEMA='SYSTEM            '
                            CREATED_BY='%'
                            REQUESTED_TABLE='COLUMN            ')

Sample QREPORT 002:

  QREPORT 002                          SQL TABLE INFORMATION              mm/dd/yy            PAGE    1

                                        SCHEMA NAME: SYSTEM
                                         TABLE NAME: COLUMN



      TIMESTAMP:        yyyy-mm-dd-hh.mm      TABLE OWNER:  MET
      DATE CREATED:     yyyy-mm-dd-hh.mm      BY USER:      MET
      DATE LAST USED:   yyyy-mm-dd-hh.mm      BY USER:      MET


      SEGMENT NAME:     SYSCAT                TABLE ID:      1028            TABLE LENGTH:          184
      AREA NAME:        DDLCAT                TABLE TYPE:   TABLE            DATA  LENGTH:          164
                                              LOC. MODE:    CLUSTERED        PREFIX LENGTH:          20
      PUT ROUTINE:                            COMPRESS:     NO               CONTROL LENGTH:         36
      GET ROUTINE:                            FORMAT:       FIXED            FIXED LENGTH:          164
                                              UPDATABLE:                     SECTION LENGTH:          0
                                              CHECKOPT:                      NUMBER OF SYNTAX:        0
      NUMBER OF COLUMNS:             19                                      DISPLACEMENT:            0
      NUMBER OF INDEXES:              0                                      ESTIMATED ROWS:          0
      NUMBER OF TIMES REFERENCED:     0                                      NUMBER PAGES:           41
      REFERENCES TO OTHER TABLES:     2                                      NUMBER ROWS:           516
                                                                             ROWS PER PAGE:           0


 COL                                                               COLUMN  COLUMN   DEFAULT
 NUM    COLUMN NAME                        DATATYPE   PREC. SCALE  OFFSET  LENGTH    VALUE    NULL ATTR.
 ---    -----------                        --------   ----- -----  ------  ------   -------   ----------

   1  NAME                              CHARACTER                      0      32      NO      NOT NULL
   2  NUMBER                            SMALLINT       15             32       2      NO      NOT NULL
   3  SCHEMA                            CHARACTER                     34      18      NO      NOT NULL
   4  TABLE                             CHARACTER                     52      18      NO      NOT NULL
   5  TYPE                              CHARACTER                     70      18      NO      NOT NULL
   6  TYPECODE                          SMALLINT       15             88       2      NO      NOT NULL
   7  PRECISION                         SMALLINT       15             90       2      NO      NOT NULL
   8  SCALE                             SMALLINT       15             92       2      NO      NOT NULL
   9  NULLS                             CHARACTER                     94       1      NO      NOT NULL
  10  DEFAULT                           CHARACTER                     95       1      NO      NOT NULL
  11  VOFFSET                           SMALLINT       15             96       2      NO      NOT NULL
  12  VLENGTH                           SMALLINT       15             98       2      NO      NOT NULL
  13  NOFFSET                           SMALLINT       15            100       2      NO      NOT NULL
  14  NLENGTH                           SMALLINT       15            102       2      NO      NOT NULL
  15  NUMVALUES                         INTEGER        31            104       4      NO      NOT NULL
  16  SECLOWVAL                         BINARY                       108       8      NO      NOT NULL
  17  SECHIGHVAL                        BINARY                       116       8      NO      NOT NULL
  18  PROCPARMTYPE                      CHARACTER                    124       1      NO      NOT NULL
  19  FILLER                            BINARY                       125      39      NO      NOT NULL