SQL Programming Manual for Pascal

HP NonStop SQL Programming Manual for Pascal—528614-001
D-1
D NonStop SQL Version Issues
The C30 release of NonStop SQL includes some features that are incompatible with
the C10 release. Usually, these features provide for compatibility with SQL ANSI and
ISO standards. If you are developing programs that will run in a mixed NonStop SQL
C10 and C30 environment, you need to ensure that your programs accommodate the
incompatible changes.
This appendix describes how C30 changes affect C10 programs and assists you in
developing a program by providing the following information:
•
Definitions for Version 1 and Version 2
•
Summary of changes in C30 that are incompatible with C10
•
Migrating a program to run on Release 2 (C30)
•
Migrating a program to access Version 2 objects
•
Recommendations for installing migrated programs
•
SQL component compatibility
•
Programmatic features for handling version control
•
Programming techniques for mixed versions
For more information about migrating to NonStop SQL C30 and managing programs in
a mixed-version NonStop SQL environment, see the NonStop SQL Installation and
Management Manual.
Version 1 and Version 2 Definitions
NonStop SQL associates a version number with features and database objects.
Version numbers are used by NonStop SQL to determine whether a current operation
can be performed on a current object. NonStop SQL provides procedures so that
programs can determine the version of objects. All features and objects have versions
as follows:
•
Version 2 data types
FLOAT (includes REAL and DOUBLE PRECISION)
DATETIME (includes DATE, TIME, and TIMESTAMP)
INTERVAL
UPSHIFT CHARACTER or VARCHAR
Caution. If you are converting a C10 program, check the program for features that have
incompatible changes. Also, ensure that the program accommodates the differences between
the C10 and C30 releases of NonStop SQL.