Contents of the extended attribute system tables

DataWindow Designer stores five types of extended attribute information in the system tables as described in Table 11-1.

Table 11-1: Extended attribute system tables

System table

Information about

Attributes

pbcatcol

Columns

Names, comments, headers, labels, case, initial value, and justification

pbcatedt

Edit styles

Edit style names and definitions

pbcatfmt

Display formats

Display format names and definitions

pbcattbl

Tables

Name, owner, default fonts (for data, headings and labels), and comments

pbcatvld

Validation rules

Validation rule names and definitions

For more about the DataWindow Designer system tables, see the Appendix in the User’s Guide.

NotePrefixes in system table names For some databases, DataWindow Designer precedes the name of the system table with a default DBMS-specific prefix. For example, the names of DataWindow Designer system tables have the prefix DBO in a SQL Server database (such as DBO.pbcatcol), or SYSTEM in an Oracle database (such as SYSTEM.pbcatfmt).

The preceding table gives the base name of each system table without the DBMS-specific prefix.