SQL Programming Manual for TAL

NonStop SQL Version Issues
HP NonStop SQL Programming Manual for TAL—527887-001
D-10
Developing C10 Programs with C30 Software
Developing C10 Programs with C30 Software
In a network, different nodes are often running different versions of NonStop SQL. If
you are developing NonStop SQL release C10 programs using NonStop SQL release
C30 software, specify the RELEASE1 option of the SQL directive. The RELEASE1
option causes the C30 TAL compiler to generate code that can be SQL compiled and
executed on either a system running either NonStop SQL release C10 or NonStop
SQL release C30.
Programs compiled with the RELEASE1 option cannot use NonStop SQL release C30
features. The TAL compiler, however, does not make a check for the use of these
features. The use of NonStop SQL release C30 features is not detected until the
program is SQL compiled on a node running NonStop SQL release C10 software.
To ensure that a program using the RELEASE1 option is error free, SQL compile and
test the program on the NonStop SQL release C10 system where it will be installed. To
install a program on a NonStop SQL release C10 system, duplicate the program object
file on the C10 system and then SQL compile the program object file.
For more information about the RELEASE1 option of the SQL directive, see Section 3,
NonStop SQL Statements and Directives.
Binding C10 and C30 Object Files
Several object files that have been compiled by different versions of the TAL compiler
(C10 and C30) can be bound together as a single unit and then SQL compiled. The
resulting object file is assigned the version of the SQL compiler. This version
information is used internally by SQL software components.
To migrate existing C10 programs that consist of multiple object files bound together to
a C30 system, follow these steps:
1. Using the C30 TAL compiler, compile only the source program files that are
modified. Adding release C30 functionality to a single module of an existing
program does not require recompiling all source modules with the TAL compiler.
2. Bind all the object files.
3. SQL compile the resulting object file with the C30 SQL compiler.
Do not pass:
•
C10 SQLDA structures from C10/C30 modules to C30 modules.
•
C30 SQLDA structures from C10/C30 modules to C10 modules.
Note. For a node running the release C10 NonStop Kernel operating system with NonStop
SQL release C10, the above PVUs must be explicitly installed. For a node running the release
C20 NonStop Kernel operating system with NonStop SQL release C10, these PVUs are
included with the C20 Guardian software, except for the BACKUP/RESTORE PVU, which does
not apply.