Description of the output of BPSQLSIA

BPSQLSIA outputs to SYSLST:

1. Information on the base tables
   Heading: INFORMATION ABOUT RELATIONAL SCHEMA subschema-name
   This includes:

   • Descriptions of the fields of each base table, including field name, data type, null-value condition, default value and additional information. Additional information may be: PRIMARY KEY SYSTEMDEFINED, UNIQUE or REFERENCES...

   • A summary of all unique keys at the set level and all unique keys at the record type level consisting of more than one field (UNIQUE summary).

   • A summary of all simple and compound keys (INDEX summary).
     The INDEX output is divided in two for all keys (e.g. compound key): the left-hand column contains the indexes that SQL can use; the right-hand column contains the indexes as defined in UDS/SQL (e.g. decomposed into items).
     Keys that have not been fully taken over into the subschema are indicated. Missing key fields are identified by three question marks.

2. Table of all limitations
   Heading: SHORT INFORMATION ABOUT RELATIONAL SCHEMA
   This includes:

   • A message indicating whether or not the subschema can be processed with SQL.

   • If the subschema can be processed with SQL, a summary of the types of SQL access permitted for each base table, under the heading:
     SHORT INFORMATION ABOUT TABLES.

3. Messages, if one or more conditions that restrict SQL access are satisfied (see "Prerequisites for SQL access to CODASYL definitions")
   (Heading: DIAGNOSTIC SUMMARY FOR SUBSCHEMANAME subschema-name)