SQL/MP Version Management Guide

Summary of Feature, Catalog, and Data Structure
Changes
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
A-2
Version 300 Features
Version 300 Features
Version 300 object definitions can include all version 1 and version 2 features, in
addition to the features listed in Table A-2.
Column attributes DEFAULT NULL
HEADING
HELP TEXT
NOT NULL
SYSTEM DEFAULT
Column values Null allowed
Constraint Conditions Defined using version 2 data types and functions
Table feature CLUSTERING KEY
Operators JOIN
UNION
Aggregate functions AVG, MIN, MAX, and SUM return a null value rather than
an error for an empty set
SQL data structures Changes to structure of SQLDA
Reserved words INNER
JOIN
LEFT
Table A-2. Version 300 Features
Feature Description
Commands GET VERSION
DOWNGRADE CATALOG
DOWNGRADE SYSTEM CATALOG
UPGRADE SYSTEM CATALOG
Clauses COLLATE, CHARACTER SET
Data types NATIONAL CHARACTER
CONTROL TABLE options JOIN METHOD
JOIN SEQUENCE
SEQUENTIAL BLOCKSPLIT
CONTROL TABLE clauses AS
BASETABLE
CONTROL QUERY option HASH JOIN
Table A-1. Version 2 Features (page 2 of 2)
Feature Description