SQL Programming Manual for TAL

HP NonStop SQL Programming Manual for TAL—527887-001
D-1
D NonStop SQL Version Issues
NonStop SQL release C30 includes features that are incompatible with NonStop SQL
release C10. Usually, these features provide compatibility with ANSI and ISO SQL
standards. This appendix describes these topics:
•
Definitions of Version 1 (C10) and Version 2 (C30) catalogs and objects
•
Changes in release C30 that are incompatible with release C10
•
Migrating a release C10 program to:
°
Run on a release C30 system
°
Access Version 2 (C30) objects
•
Installing migrated programs
•
SQL component compatibility
•
Programmatic features for handling version control
•
Programming techniques for mixed versions
For more information about version issues for NonStop SQL release C10 and NonStop
SQL release C30, see the
NonStop SQL Installation and Management Manual.
Version 1 and Version 2 Definitions
NonStop SQL associates a version number with each SQL feature and database
object. NonStop SQL uses this version number to determine whether it can support a
feature or an object. If it cannot support a feature or an object, NonStop SQL also uses
the version number to return an appropriate message. NonStop SQL Version 1 and
Version 2 features and objects are described in the following paragraphs.
The Version 2 data types are:
•
FLOAT (includes REAL and DOUBLE PRECISION)
•
DATETIME (includes DATE, TIME, and TIMESTAMP)
•
INTERVAL
•
UPSHIFT CHARACTER or VARCHAR
The Version 2 functions are:
•
Exponentiation
•
Date-time functions
•
UPSHIFT function
The Version 2 features are:
•
Version 2 data types and functions (shown above)