SQL Programming Manual for Pascal

NonStop SQL Version Issues
HP NonStop SQL Programming Manual for Pascal—528614-001
D-2
Version 1 and Version 2 Definitions
•
Version 2 functions
Exponentiation
Date-time functions
UPSHIFT function
•
Version 2 features
Version 2 data types
Version 2 functions
Ability of columns to contain null values
Clustering keys
Constraints with constants using any Version 2 feature
NO AUDITCOMPRESS attribute
HEADING attribute
HELP TEXT attribute
UNION clause of the SELECT statement
JOIN clause of the SELECT statement
•
Version 2 table—A table that uses any Version 2 feature.
•
Version 2 index—An index that includes any column with a Version 2 data type, or
uses any Version 2 features.
•
Version 2 protection or shorthand view—A view whose underlying table is a
Version 2 table or whose selection expression includes a Version 2 feature such as
a Version 2 constant, or UNION or JOIN.
•
Version 2 object—A Version 2 table, index, or view.
•
Version 2 catalog—A catalog with the C30 catalog format. Such a catalog can be
created either by NonStop SQL C30 software or created by C10 software and
upgraded with the C30 UPGRADE CATALOG command using NonStop SQL C30
software. Both Version 1 and Version 2 objects can be registered in a Version 2
catalog. A Version 2 catalog has more columns and column values than a Version
1 catalog.
The new columns in Version 2 catalogs are summarized in Table D-1
on page D-3,
following. For column values, see the NonStop SQL Installation and Management
Manual.
•
Version 1 object—A table, index, or view that does not include Version 2 features.
NonStop SQL C10 always creates Version 1 objects. NonStop SQL C30 creates
both Version 1 and Version 2 objects. An object is Version 2 if it uses any Version 2
features; otherwise, the object is Version 1.
•
Version 1 catalog—A catalog with the C10 catalog format. Only Version 1 objects
can be registered in a Version 1 catalog; Version 2 objects cannot. Version 2
objects often require the new catalog column format of Version 2 catalogs to fully
describe an object. Programs compiled by either the C10 or C30 SQL compiler,
however, can be registered in a Version 1 catalog.
Table D-1 on page D-3 summarizes the new columns in Version 2 catalogs.