SQL/MP Version Management Guide

Version Compatibility for SQL Programs

Compaq NonStop™ SQL/MP Version Management Guide—429833-001

7-10

Reverting to an Older Release

If you are developing an SQL program by using a new version of SQL/MP software and

the program is to run on multiple versions or releases of SQL/MP, you should:

•

Check that the host language compiler on your development system matches the

oldest SQL/MP version of the node on which the program is to run.

•

Make sure that the operating-system release of the host language compiler is

compatible with the version of SQL/MP software on the node where the compiled

program is to run.

For example, if a program is to execute on a node that uses version 2 SQL software

and the C-series operating system and you have both a C-series host language

compiler and a D-series host language compiler, you must use the C-series compiler.

•

Use conditional compilation to allow new features to run on D-series nodes if your

system includes both C-series and D-series software. If your system includes either

C-series or D-series software, but not both, you cannot use SQL features newer than

C-series.

For more detailed information on migrating from C-series to D-series, see the D-Series

System Migration Planning Guide; for information on converting applications from C-

Series to D-Series, see the Guardian Application Conversion Guide.

Figure 7-2. Results of Using an Older-Release Compiler

Source Program

Node Running

Version 2 (D-Series) NonStop SQL

Node Running

Version 2 (C-Series) NonStop SQL

(Reverted From D-Series)

Host Language

Compiler

Host Object File

SQL Compiler

Compilation attempt results in version error.

VST016.vsd

Version 2

Code

SQL Version=2

D-Series

HOSV=2

D-Series

HOSV=2

D-Series

Version 2

C-Series