CA IDMS/DB SQL Dictionary Reports—QREPORTS › QREPORT 007 -SQL Table Index Report › Job Submission

Job Submission

The following example will retrieve QRPT007 syntax from the DIRLDICT dictionary of IDD and will provide an index report of all tables in the SYSTEM schema of the TSTDICT dictionary.

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

Sample QREPORT 007:

 QREPORT 007                                SQL TABLE INDEX REPORT             mm/dd/yy       PAGE     1

                                            SCHEMA NAME: SYSTEM


                                   SCHEMA.TABLE /
               INDEX NAME          INDEX COLUMNS                    ORDER   OTHER SPECIFICATIONS
               ──────────          ──────────────                   ─────   ────────────────────

UNIQUE INDEX   HASH                ON SYSTEM.AM
                                  (NAME                              ASC,
                                   VERSION                           ASC)
                                                                            UNCOMPRESSED
                                                                            CLUSTERED

UNIQUE INDEX   HASH                ON SYSTEM.AREA
                                  (NAME                              ASC,
                                   SEGMENT                           ASC)
                                                                            UNCOMPRESSED
                                                                            CLUSTERED

UNIQUE INDEX   IX-AREA             ON SYSTEM.AREA
                                  (NAME                              ASC,
                                   SEGMENT                           ASC)
                                                                            UNCOMPRESSED
                                                                            IN SYSCAT.DDLCATX
                                                                            INDEX BLOCK CONTAINS    10 KEYS
                                                                            DISPLACEMENT IS     3 PAGES

UNIQUE INDEX   IX-BUFFER           ON SYSTEM.BUFFER
                                  (NAME                              ASC,
                                   DMCL                              ASC)
                                                                            UNCOMPRESSED
                                                                            IN SYSCAT.DDLCATX
                                                                            INDEX BLOCK CONTAINS    10 KEYS
                                                                            DISPLACEMENT IS     3 PAGES

UNIQUE INDEX   IX-CONSTRAINT       ON SYSTEM.CONSTRAINT
                                  (SCHEMA                            ASC,
                                   NAME                              ASC)
                                                                            UNCOMPRESSED
                                                                            IN SYSCAT.DDLCATX
                                                                            INDEX BLOCK CONTAINS    10 KEYS
                                                                            DISPLACEMENT IS     3 PAGES

UNIQUE INDEX   IX-DBNAME           ON SYSTEM.DBNAME
                                  (DBTABLE                           ASC,
                                   NAME                              ASC)
                                                                            UNCOMPRESSED
                                                                            IN SYSCAT.DDLCATX
                                                                            INDEX BLOCK CONTAINS    10 KEYS
                                                                            DISPLACEMENT IS     2 PAGES

UNIQUE INDEX   HASH                ON SYSTEM.DBTABLE
                                  (NAME                              ASC)