SQL/MP Version Management Guide

Compaq NonStop™ SQL/MP Version Management Guide—429833-001
5-1
5
Program Versions
SQL Program Creation
To understand the information presented in this section, you should have a basic
understanding of how SQL programs are created. With the SQL programmatic interface,
you can embed SQL statements and directives in a C, COBOL85, Pascal, or TAL
program.
The steps you use to create an SQL program follow:
1. Write the program in a source file using host language statements and SQL
statements and directives.
2. Compile the host language statements using the host language compiler. Optionally,
you can preprocess a COBOL85 source file before compiling it with the COBOL85
compiler.
The output of a host language compilation is called a host object SQL file. A host
object SQL file contains both object code and SQL source statements.
3. If you have multiple object files, run the Binder program to combine the files into
one host object SQL file.
4. Compile your host object SQL file using the NonStop SQL/MP compiler. The
output from this step is an executable SQL program.
The preceding steps can vary slightly, depending on the programming language in which
your program is written. For more information about compiling and executing SQL
programs, see the NonStop SQL/MP Programming Manual for the language you are
using.
SQL Versions of Host Language Compiler and Host
Object File
SQL version numbers are assigned to host language compilers and to host object files
produced by host language compilers.
A host language compiler SQL version number is an SQL version number assigned to a
host language compiler or COBOL85 preprocessor. The version number identifies the
oldest version of the SQL/MP software with which the compiler or COBOL85
preprocessor is compatible.
A host object SQL version (HOSV) is an SQL version number assigned to a host object
SQL file. The HOSV identifies the oldest-version SQL compiler that can be used to
compile the file.
Host Language Compiler SQL Version
The SQL version of a host language compiler or COBOL85 preprocessor identifies the
oldest version of SQL/MP that is compatible with the compiler or preprocessor. The