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

Job Submission

The following example reports on all schemas residing in the TESTDICT dictionary whose schema name begins with EMP:

DATABASE DICTNAME=dictionary-name
USE "QRPT003"  WITH VALUES (REQUESTED_DICTIONARY='TSTDICT'
                            REQUESTED_SCHEMA='EMP%')

Sample QREPORT 003 (Page 1):

  QREPORT 003                          SQL SCHEMA INFORMATION                  mm/dd/yy                 PAGE     1

                                        SCHEMA NAME: EMPLDEMO




                                                 SCHEMA OWNER: MET
      DATE CREATED:      yyyy-mm-dd-hh.mm        BY USER:      MET
      DATE LAST UPDATED:                         BY USER:

      SEGMENT NAME:                              SCHEMA TYPE:  RELATIONAL
      AREA NAME:



                           TABLE                                   TOTAL  NUMBER   NUMBER      TIMES       REFERENCES
        TABLE NAME          ID    TABLE TYPE  CREATED BY           LENGTH COLUMNS  INDEXES   REFERENCED   OTHER TABLES
        ----------         -----  ----------  ----------           ------ -------  -------   ----------   ------------

      BENEFITS              1028   TABLE      MET                112      19        1          0             0
      COVERAGE              1029   TABLE      MET                 28       5        1          0             0
      DEPARTMENT            1028   TABLE      MET                 52       4        1          0             0
      DIVISION              1029   TABLE      MET                 48       3        1          0             0
      EMPLOYEE              1030   TABLE      MET                172      15        1          0             0
      INSURANCE_PLAN        1030   TABLE      MET                160      13        1          0             0
      JOB                   1031   TABLE      MET                180       9        1          0             0
      POSITION              1031   TABLE      MET                 52       9        1          0             0

Sample QREPORT 003 (Page 2):

  QREPORT 003                          SQL SCHEMA INFORMATION                  mm/dd/yy                 PAGE     2

                                        SCHEMA NAME: EMPSCHM




                                                 SCHEMA OWNER:
      DATE CREATED:      yyyy-mm-dd-hh.mm        BY USER:
      DATE LAST UPDATED:                         BY USER:

      SEGMENT NAME:     EMPDEMO                  SCHEMA TYPE:  NON-SQL REFERENCING
      AREA NAME:

      NON-SQL NODE:                              REFERENCED NON-SQL SCHEMA:  EMPSCHM
      NON-SQL DICTNAME: APPLDICT                 SCHEMA VERSION:               100



                                       THIS SCHEMA HAS NO TABLES CURRENTLY DEFINED