CA IDMS/DB SQL Dictionary Reports—QREPORTS › QREPORT 002 -Table and Column Report › Field Descriptions

Field Descriptions

A description of the fields in QREPORT 002 follows:

SCHEMA NAME

The name of the schema.

TABLE NAME

The name of the table.

TIMESTAMP

Table timestamp, used for synchronization with access module definitions.

TABLE OWNER

The owner of the schema in which this table resides.

DATE CREATED, BY USER

The userid of the person who submitted the SQL CREATE TABLE DDL, and the date and time the table was created.

DATE LAST UPDATED, BY USER

The userid of the person who last altered the table definition, and the date and time it occurred.

SEGMENT NAME

Name of the segment associated with the area where table rows are stored.

TABLE ID

Internal table identifier which identifies the rows of the table within an area.

TABLE LENGTH

The total length of a row of tables.

AREA NAME

Name of area where table rows are stored.

TABLE TYPE

The type of table. Valid values are:

• Base table
• Function
• Procedure
• Record in a non-SQL defined schema
• Table procedure
• View

DATA LENGTH

Internal length of the data portion of a table row (including 4-byte RDW for a compressed table).

LOC. MODE

The valid location modes are:

• CALC
• CLUSTERED
• DIRECT
• ROW ID INDEXED
• UNIQUE CALC

KEY LENGTH

Internal length of the non-data portion (the prefix length) of a table row.

PUT ROUTINE

CA IDMS Presspack data characteristic table (DCT) name.

COMPRESS

Compress indicator:

• 'Y' - Compressed
• 'N' - Uncompressed
• 'P' - Compressed with CA IDMS Presspack

CONTROL LENGTH

Internal length of the control portion (without the prefix) of a table row.

FORMAT

Format of the table row:

• 'F' - Fixed length
• 'V' - Variable length (compressed tables only)

FIXED LENGTH

Internal length of the fixed portion (without the prefix) of the table row.

UPDATABLE

When TYPE is 'V', updatable view indicator:

• 'Y' - Updatable
• 'N' - Not updatable

SECTION LENGTH

Length of the I-tree stored in the associated section table rows.

CHECKOPT

When TYPE is 'V', WITH CHECK OPTION indicator:

• 'Y' - View defined with WITH CHECK OPTION
• 'N' - View defined without WITH CHECK OPTION

NUMBER OF SYNTAX

Number of the "create view" or "create/alter table" DDL syntax records stored in the SYNTAX table. Create and alter table syntax is present only if it contains a CHECK clause.

NUMBER OF COLUMNS

Number of columns in the table or view.

DISPLACEMENT

Displacement, in pages, from clustering index or referenced row in a clustering constraint.

NUMBER OF INDEXES

Number of indexes on the table.

ESTIMATED ROWS

Estimated number of rows in the table.

NUMBER OF TIMES REFERENCED

Number of constraints in which the table is the referenced table.

NUMBER PAGES

Number of pages containing rows of the table when statistics were last updated.

REFERENCES TO OTHER TABLES

Number of constraints where this table is the referencing table.

NUMBER ROWS

Actual number of rows in the table when statistics were last updated.

ROWS PER PAGE

Number of table rows per page when statistics were last updated.

EXTERNAL NAME

Specifies the name of the program which will be called to process references to the procedure.

LOCAL WORK AREA

Represents the size of a local storage area that CA IDMS allocates at runtime and passes to each invocation of a procedure.

TRANSACTION SHARING

Specifies whether to enable transaction sharing for database sessions started by the procedure. Valid values are:

• ON—enable transaction sharing
• OFF—disable transaction sharing
• DEFAULT—retain the transaction sharing option in effect when the procedure is invoked

MODE

The mode in which the procedure executes. Valid values are:

• USER
• SYSTEM

GLOBAL WORK AREA

Represents the size of a global storage area that CA IDMS allocates at runtime and passes to each invocation of a procedure.

DEFAULT DATABASE

Specifies whether to establish a default database for database sessions started by the procedure. Valid values are:

• NULL—specifies not to establish a default database
• CURRENT—specifies to establish the database to which the SQL session is connected as the default database

PROTOCOL

Specifies the protocol to use to invoke the procedure. Valid values are:

• IDMS—for procedures written in COBOL, PL/I, or Assembler
• ADS—for procedures written in CA ADS

SHARED KEY

Specifies an identifier for the global storage area.

COL NUM

The column number in the table.

COLUMN NAME

The relative position of the column in the table.

DATATYPE

The data type for the named column.

PREC.

The number of digits in a numeric value.

SCALE

The number of digits to the right of the decimal point in a numeric value.

COLUMN OFFSET

The offset within a row into the data value of the column.

COLUMN LENGTH

The internal length of the column data value.

DEFAULT VALUE

Indicates whether or not the WITH DEFAULT clause was specified for this column.

NULL ATTR.

Indicates whether or not nulls are allowed.