SQL/MP Version Management Guide
Summary of Feature, Catalog, and Data Structure
Changes
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
A-8
Catalog Changes in Version 315
Table A-8 lists the data structure changes made in version 310.
Catalog Changes in Version 315
In version 315 of SQL/MP, the OSSFILE column was added to the PROGRAMS table.
Catalog Changes in Version 320
In version 320 of SQL/MP, the PARTITIONARRAY column was moved from the
TABLES table to the FILES table.
Table A-9
lists the data structure changes made in version 320.
Catalog Changes in Versions 325, 330, 335, and 340
No changes were made to the catalog tables for these versions.
Catalog Changes in Version 345
In Version 345 of SQL/MP, the DCOMPRESSTYPE column was added to the FILES
table.
Catalog Changes in Version 350
Columns were added in the FILES table to support Format 2 partition enabling. A new
value, FORMAT2ENABLED, was allowed for the PARTITIONARRAY column.
Table A-8. Table Changes in Version 310
Changes Columns affected
Columns added to the
PROGRAMS table
FORCE
SIMILARITYINFO
RECOMPILEMODE
CHECKMODE
REGISTERONLY
Columns added to the
TABLES table
SIMILARITYCHECK
Table A-9. Table Changes in Version 320
Changes Columns affected
Columns added to the FILES
table
PARTITIONARRAY
Columns removed from the
TABLES table
PARTITIONARRAY