SQL/MP Version Management Guide

Summary of Feature, Catalog, and Data Structure
Changes
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
A-6
Catalog Changes in Version 300
Table A-6 lists the changes in tables introduced with version 2.
Catalog Changes in Version 300
In version 300, two new tables were introduced, and new columns were added to several
existing tables. Also, new values are allowed for existing columns in tables. These
changes are listed in Table A-7.
Table A-6. Table Changes in Version 2
Changes Columns Affected
New Columns in the
COLUMNS table
DATETIMESTARTFIELD
DATETIMEENDFIELD
DATETIMEQUALIFIER
UPSHIFT
HEADING
HEADINGTEXT
Columns in the COLUMNS
table that might have new
values
DATATYPE
FSDATATYPE
COLSIZE
SCALE
PRECISION
OFFSET
NULLALLOWED
DEFAULTCLASS
DEFAULTVALUE
PICTURETEXT
New columns in the FILES
table
The AUDITCOMPRESS column stores the value of the
AUDITCOMPRESS attribute of a file.
New value allowed in the
COMMENTS table
HC in the OBJTYPE column means the comment applies to
help text.
Table A-7. Table Changes in Version 300 (page 1 of 2)
Changes Tables or Columns Affected
New tables
CPRULES describes attributes of collations.
CPRLSRCE contains the source from which collations
are created.
New column in the
CATALOGS table
CATALOGVERSION records the version of the catalog
in integer form. For a description of the values in this
column, see Section 3, Database Versions
.
New columns in the
COLUMNS table
CPRULESNAME records the name of the collation that
determines the default collating sequence for values of
the column. (Use the COLLATE clause to specify a
different collating sequence.)
CPARRAYENTRY is reserved for system use.
CHARACTERSET records the character set used for
values of the column.