SQL Programming Manual for Pascal

NonStop SQL Version Issues
HP NonStop SQL Programming Manual for Pascal—528614-001
D-9
SQL Component Compatibility
SQL statements will follow C30 functioning when a C10 program runs on a C30
system.
The recommended procedure for installing programs includes SQL compiling all SQL
program object files with the C30 release of the SQL compiler. SQL compilation
performs error checking for potential version problems.
The steps to install migrated programs are as follows:
1. Alter all source program modules affected by incompatible C30 features.
2. Pascal compile the programs that have embedded SQL statements.
3. Run Binder. (Binding multiple C10 and C30 object files is discussed later in this
appendix.)
4. SQL compile all SQL program object files with the C30 release of the SQL
compiler.
After SQL compilation, the program has been installed and is ready for execution.
SQL Component Compatibility
All the software on a system is assumed to be of a single release version: either
NonStop SQL C10 (Release 1) software or NonStop SQL C30 (Release 2) software.
NonStop SQL installation procedures warn against mixing SQL system components
from different SQL versions because of the risk of unpredictable errors.
If NonStop SQL C30 is installed on a network with other NonStop SQL C10 systems,
all the NonStop SQL C10 systems that are to communicate with the C30 systems must
be running the SQL C10 Versioning IPM. This IPM contains enhancements for
handling compatibility between SQL system components and SQL objects. The
components and IPM numbers are listed in Table D-4.
Table D-4. SQL C10 Versioning IPM Summary (page 1 of 2)
Component Name IPM Numbers
Component
Identification
BACKUP/RESTORE T9074C10^06MAR89 T9074AAM
TSQL T9095C10^06MAR89 T9095AAG
TSQLCI T9191C10^06MAR89 T9191AAC
TSQLCOB T9192AAD^06MAR89 T9192AAD
TSQLEXE T9193C10^15MAR89 T9193AAF
TSQLCAT T9194C10^06MAR89 T9194AAD
TSQLUTI T9195C10^06MAR89 T9195AAD
TSQLMSG T9197C10^06MAR89 T9197AAC