To view the SQL schema SQL catalog, you can use the Schema Administrator LIST command. The output from the LIST command also contains information about Enterprise Database Server constructs that were not modeled.
For more information on how DASDL constructs are handled in the relational schema, refer to Understanding Relational Mappings for SQL. For information on the Schema Administrator LIST command, refer to Listing the Description later in this section.
| Note: | The LIST command produces certain constructs to provide further information about the SQLVIEW descriptions; however, these constructs are not accepted as a valid SQL DDL syntax. If the MCPSQL-CATALOG file exists, the LIST and SQLVIEW command procedures can only be called by the owner of the database. |
You should review all attributes on the SQL schema to determine the SQL characteristics enforced by the system. For example, if an entity cannot be fully updated, the Schema Administrator assigns appropriate schema constraints like READONLY so that errors can appear through normal SQL processing.
