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

QREPORT 007 -SQL Table Index Report

QREPORT 007, the SQL Table Index report, provides information about each index that is associated with the schema and table requested. For requests involving multiple schemas and tables, the report is sorted by schema name, table name, and index name.

Indexes with a name of HASH represent calc keys defined on a base table using the SQL CREATE CALC key syntax. On the final release of QRPT007, the word CALC will appear in column 9 instead of INDEX HASH.

The report layout is generated in the form of syntax which is similar to that used to create the index.