SQL/MP Version Management Guide

Summary of Feature, Catalog, and Data Structure
Changes
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
A-7
Catalog Changes in Version 310
Catalog Changes in Version 310
In version 310 of SQL, new columns were added to the PROGRAMS and TABLES
tables. Also, new values are allowed for existing columns in the PROGRAMS,
TABLES, and VERSION tables.
New values allowed in the
COLUMNS table
New values are allowed in the FSDATATYPE column
corresponding to the new data type, NCHAR.
New columns in the
INDEXES table
OBJECTVERSION records the object versions of
indexes.
SECURITYMODE records the type of security used for
the index; set to G for Guardian security.
SECURITYVECTOR records the security vector
(Guardian security string) used to secure the index.
New column in the KEYS
table
CPRULESNAME records the name of the collation that
is used to collate an index.
New columns in the
PROGRAMS table
SECURITYMODE records the type of security used for
the program; set to G for Guardian security.
PROGRAMFORMATVERSION records the format
version of a program.
PROGRAMCATALOGVERSION records the catalog
version of a program. For a description of program
format version and program catalog version, see
Section 5, Program Versions
.
New columns in the
TABLES table
SECURITYMODE records the type of security used for
the program; set to G for Guardian security.
OBJECTVERSION records the object versions of tables
and views. For a description of object versions, see
Section 3, Database Versions
.
New values allowed in the
TABLES table
A value of CP in the TABLETYPE column refers to a
collation object.
New columns in the
VERSIONS table
CATALOGVERSION records the version of a catalog.
CATALOGFORMAT records the format of a catalog.
For a description of catalog version and catalog format,
see Section 3, Database Versions
.
New value allowed in the
COMMENTS table
CP in the OBJECTTYPE column means that the
comment applies to a collation.
New value allowed in the
USAGE table
CP in the USEDOBJTYPE column specifies a
dependency on a collation.
Table A-7. Table Changes in Version 300 (page 2 of 2)
Changes Tables or Columns Affected