CA IDMS/DB SQL Dictionary Reports—QREPORTS › Overview

Overview

CA IDMS/DB SQL Dictionary Reports present information about entities defined to CA IDMS/DB using SQL commands. These reports provide Database Administrators with detailed information about the contents of the SQL Dictionary, and allow application programmers to obtain selected information from the SQL Dictionary.

QREPORTS consist of CA Culprit for CA IDMS syntax that is stored in either a partitioned data set or as modules of language CULPRIT in the CA IDMS/DB Integrated Data Dictionary. You can execute them, one at a time, by submitting a CA Culprit for CA IDMS job in batch. Because each QREPORT has its own unique SQL Select clause for database retrieval, each report must be run separately.

You submit QREPORTS using the USE parameter. Enclosing the report name in double quotes on a CA Culprit for CA IDMS USE statement has a very explicit meaning. The syntax USE "QRPT001" tells CA Culprit for CA IDMS to read the highest version of module QRPT001 with language CULPRIT from the CA IDMS/DB IDD.

The syntax USE QRPT001 (without double quotes) tells CA Culprit for CA IDMS to read the QRPT001 member from the partitioned dataset named by the CULLIB DD statement in the JCL.

The optional WITH VALUES clause of the USE syntax allows you to override the default values of symbolic parameters embedded in the QREPORT syntax. Since the reports are coded with the LIKE predicate, wildcards may be used when specifying these symbolic parameters. If wildcards are not used, however, the LIKE behaves as the equivalent of a comparison using an equal sign, with the restriction that the lengths of the two values being compared must be identical. Each QREPORT is documented with the symbolic parameters available and their lengths. For more information on the LIKE predicate, see the CA IDMS SQL Reference Guide.

There are eight available CA IDMS/DB Dictionary Reports: QREPORTs 001 through 008.