11. OpenSQL Standard Catalogs : System Catalog Characteristics
 
Share this page                  
System Catalog Characteristics
Unless otherwise noted, values in system catalogs are left justified, and columns are non-nullable.
The length of char fields, as listed in the Data Type column, is a maximum length. The actual length of the field is installation-dependent. When developing applications that access these catalogs, allocate storage based on the length as shown in the Data Type column.
All dates stored in system catalogs have the following format (underscores and colons are required):
yyyy_mm_dd hh:mm:ss GMT (Greenwich Mean Time)
Note:  In this chapter, “default” means the assumed value if no other value is present.