SQL/MP Version Management Guide

Program Versions
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
5-3
Retrieving the Host Language Compiler SQL Version
This figure illustrates the relationship of the host language compiler SQL version and
the host object SQL version to the version of an SQL compiler:
Retrieving the Host Language Compiler SQL Version
You can retrieve the SQL version of a host language compiler that has produced a host
object file in either of two ways:
•
By running the VPROC program
•
By compiling the file by using the SQLMAP option of an SQL directive or pragma
The VPROC program is a utility that displays the SQL version of a host language
compiler. The SQLMAP option can be used with an SQL directive or pragma to include
version information in compiler listings.
Running VPROC to Retrieve Host Language Compiler SQL
Version
The VPROC program can help when you need a quick method for checking the SQL
version of a host object; for example, at installation time or when a problem must be
reported.
When you run VPROC, it produces output that includes two lines of this format:
S7094D30_ddmmyy_SQL310_ddmmyy
Each line of output generated by VPROC is divided into several parts. In the preceding
example, S7094 is the product number of the SQL portion of the compiler running the
VPROC program. The ddmmyy values refer to release and build dates, and the third
group of numbers on the line (in this case, SQL310) is the SQL version of the host
language compiler.
Using SQLMAP to Display Host Language Compiler SQL Version
When you compile a source program by using the SQLMAP option of the SQL
directive, the compiler places the SQL version of the host language compiler in a block
of text at the end of the compiled source-file listing.
To print the SQL version of a C compiler at the end of a compiled listing, place the
following pragma in your C program’s source file:
#pragma SQL SQLMAP
Host Language Compiler
SQL Version
Maximum Host Object
SQL Version
SQL Compiler
Version
=<=
VST009.vsd
Host Language
Compiler
Host Object
SQL File
SQL Compiler