Using the Relational Data Framework › Tables the Product Provides

Tables the Product Provides

Since it is so important to know the default values in your tables and the names of the tables and columns in which your data resides, CA OPS/MVS provides three tables that describe all CA OPS/MVS relational tables:

• The table named TABLE contains the names of relational tables.
• The table named COLUMN defines the columns in each table.
• The table named DEFAULT contains one row for each table that has default values; the row contains all of the default values for the table.

You cannot search, delete, or alter the DEFAULT table. The TABLE and COLUMN tables are data dictionary tables. You can search them, but you cannot delete or alter them. When you create or alter any other table using the SQL statements described in this chapter, an entry is made by CA OPS/MVS in the TABLE table for each new table, the COLUMN table for each new column, and the DEFAULT table for each new default value (if any were defined).