SQL Programming Manual for TAL

NonStop SQL Version Issues
HP NonStop SQL Programming Manual for TAL—527887-001
D-9
SQL Component Compatibility
1. Alter all source program modules affected by incompatible C30 features.
2. TAL compile the programs that contain embedded SQL statements.
3. Bind object files if this step applies. Binding multiple C10 and C30 object files is
discussed later in this appendix.
4. Optionally, run the Accelerator on the object file generated from Step 2 or 3 if you
plan to run the object file on a TNS/R system.
5. SQL compile all SQL program object files with the C30 SQL compiler.
6. Install the program object file on the C30 system.
SQL Component Compatibility
All software on a system should be a single release version: either NonStop SQL
release C10 or NonStop SQL release C30. NonStop SQL installation procedures warn
against mixing SQL system components from different versions because of the risk of
unpredictable errors.
If NonStop SQL release C30 is installed on a network with NonStop SQL release C10
systems, all release C10 systems that are to communicate with the C30 systems must
be running the SQL C10 Versioning PVU (or any later PVUs that supersede the
Versioning PVU).
The Versioning PVU contains enhancements for handling compatibility between SQL
system components and SQL objects. The components and PVU numbers are listed in
the Table D-6
.
Table D-6. Release C10 Versioning IPM Summary
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
TSQLCI2 T9198C10^06MAR89 T9198AAA
FASTSORT T9620C10^14FEB89 T9620AAB