SQL Programming Manual for TAL

NonStop SQL Version Issues
HP NonStop SQL Programming Manual for TAL—527887-001
D-2
Version 1 and Version 2 Definitions
•
Columns that can contain null values
•
Clustering keys
•
Constraints with constants using any Version 2 feature
•
NO AUDITCOMPRESS, HEADING, and HELP TEXT attributes
•
UNION and JOIN clauses of the SELECT statement
Table D-1
shows the Version 2 entities and their descriptions.
Table D-2
shows the Version 1 entities and their descriptions.
To determine a version number, a program can call the SQLGETCATALOGVERSION,
SQLGETOBJECTVERSION, or SQLGETSYSTEMVERSION system procedure. The
procedures are described in Section 4, System Procedures
A Version 2 catalog has more columns and column values than a Version 1 catalog.
Table D-3
summarizes the new columns in Version 2 catalogs. For the column values,
see the
NonStop SQL Installation and Management Manual.
Table D-1. Version 2 Items and Descriptions
Version 2 Entity Description
Table A table that uses any Version 2 feature.
Index An index that includes any column with a Version 2 data type or
that uses any Version 2 feature.
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.
Object A Version 2 table, index, or view.
Catalog A catalog with release C30 format. It can be created by NonStop
SQL C30 software, or it can be created by C10 software and
then upgraded with the C30 UPGRADE CATALOG command.
Both Version 1 and Version 2 objects can be registered in a
Version 2 catalog.
Table D-2. Version 1 Items and Descriptions
Version 1 Entity Description
Object A table, index, or view that does not include any Version 2
features. NonStop SQL release C10 always creates Version 1
objects, but NonStop SQL release C30 can create Version 1 and
Version 2 objects.
Catalog A catalog with NonStop SQL release C10 format. Only Version 1
objects can be registered in a Version 1 catalog. However,
programs compiled by either the release C10 or C30 SQL
compiler can be registered in a Version 1 catalog.