CA IDMS/DB SQL Dictionary Reports—QREPORTS › QREPORT 001 -SQL Column Name Report › Job Submission

Job Submission

This syntax will list all of the columns from the SYSTEM schema of the TSTDICT SQL dictionary.

DATABASE DICTNAME=dictionary-name
USE "QRPT001"  WITH VALUES (REQUESTED_DICTIONARY='TSTDICT'
                            REQUESTED_SCHEMA='SYSTEM            '
                            REQUESTED_COLUMN='%')

Sample QREPORT 001:

QREPORT 001                                 SQL  COLUMN NAME  REPORT                               mm/dd/yy       PAGE      3


                                                                                 COLUMN / NULL               COL NUM
                                  SCHEMA NAME /       DATATYPE /                        INTERNAL  DEFAULT      IN
  COLUMN NAME                     TABLE NAME          NULL ATTR.   PREC. SCALE   OFFSET  LENGTH    VALUE      TABLE
  ───────────                     ─────────────       ───────────  ───── ─────   ──────  ──────   ───────     ──────

NUMBER                            SYSTEM              SMALLINT       15            130       2      NO            5
                                  RESOURCE            NOT NULL

NUMBLOCKS                         SYSTEM              INTEGER        31             92       4      NO            9
                                  JOURNAL             NOT NULL

NUMBUFFERS                        SYSTEM              SMALLINT       15             94       2      NO            9
                                  DMCL                NOT NULL

NUMCOLS                           SYSTEM              SMALLINT       15            162       2      NO           26
                                  TABLE               NOT NULL

NUMCOLUMNS                        SYSTEM              SMALLINT       15            116       2      NO            8
                                  CONSTRAINT          NOT NULL

NUMCOLUMNS                        SYSTEM              SMALLINT       15             92       2      NO            8
                                  INDEX               NOT NULL

NUMDADS                           SYSTEM              SMALLINT       15             96       2      NO           12
                                  SEGMENT             NOT NULL

NUMDBNAMES                        SYSTEM              SMALLINT       15             62       2      NO            7
                                  DBTABLE             NOT NULL

NUMFILEMAPS                       SYSTEM              SMALLINT       15             96       2      NO           11
                                  AREA                NULLS ALLOWED                 95       1