Previous Topic: Accessing Database and Logical RecordsNext Topic: Qualified Field Name References


Accessing Tables

In a CA Culprit run that consolidates one or more tables, the first 95 bytes of the CA Culprit input buffer contain fields that can be used to determine the table associated with the row that is in the input buffer. Users can access these fields by using reserved keywords.

Reserved keywords can be referenced on SORT, edit, process, and SELECT/BYPASS parameters. Database-Specific Process Parameters identifies the appropriate keywords for each type of process operation.

Keywords

Each keyword is described separately below:

TABLE-ID

Is a 3-byte zoned decimal field that indicates which data table is currently being accessed. Ids are assigned in the order the tables are read. The primary table ID is 001, the second table ID is 002, and so on.

TABLE-NAME

Is a 56-byte alphanumeric field that contains the table name supplied on the INPUT parameter TABLE= keyword.

SUBSCHEMA-NAME

Is an 8-byte alphanumeric field that contains the subschema name of the table currently being read.