SQL/MP Version Management Guide

Summary of Feature, Catalog, and Data Structure
Changes
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
A-3
Version 310 Features
Version 310 Features
Version 310 object definitions can include all version 1, version 2, and version 300
features, in addition to the features listed in Table A-3.
Version 315 Features
No new object definitions were introduced with version 315.
Version 335 Features
Version 335 object definitions can include all version 1, version 2, and version 300
features, in addition to the features listed in Table A-4.
Version 345 Features
Version 345 added a new compression type.
Version 350 Features
Version 350 added support for Format 2 enabled tables and indexes. Format 2 enabled
tables and indexes are objects that are at least Version 350 that must be registered in a
catalog that is at least Version 350.
Views on Format 2 enabled objects must be at least Version 350 objects.
Programs using Version 350 objects must be at least HOSV 350 programs.
Version 350 object definitions can include all version 1, version 2, version 300, and
version 335 features, in addition to the features listed in Table A-5
.
Table A-3. Version 310 Features
Feature Description
Clauses SIMILARITY CHECK clause on the CREATE TABLE,
CREATE VIEW, ALTER TABLE, and ALTER VIEW
statements
CONTROL QUERY
directive
BIND NAMES option
Table A-4. Version 335 Features
Feature Description
CONTROL TABLE Join method key sequenced merge
MDAM option
Access path MDAM
CONTROL QUERY option MDAM option