SQL/MP Programming Manual for C

Introduction

HP NonStop SQL/MP Programming Manual for C—429847-008

1-7

SQL/MP Version Management

Each product version update (PVU) of NonStop SQL/MP has an associated version

number. The first two PVUs were version 1 (C10 and C20) and version 2 (C30).

Version 300 SQL/MP began using a three-digit version number to allow for software

product revisions (SPRs).

A new version number is always greater than the previous number, but the new

number might not follow a constant increment. For example, consecutive version

numbers after version 340 might be 345, 350, and 360.

In addition, SQL objects (tables, indexes, views, collations, and constraints), programs,

and catalogs have associated version numbers. This version number indicates the

SQL features used by the SQL object or program and the SQL/MP software with which

the SQL object or program is compatible. For example, a version 2 table might use the

date-time data types or allow null values in a column. A version 2 table is compatible

with version 2 and version 315 SQL/MP software, but it is not compatible with version 1

software.

This manual includes this version information:



Using compatible versions of the C compiler, SQL compiler, and SQL executor to

compile and run a program



Using the data status language (DSL) statements: GET VERSION (for SQL

objects, catalogs, and SQL/MP software), GET VERSION OF PROGRAM, and

GET CATALOG OF SYSTEM



Generating different versions of the SQLSA and SQLDA structures



Using run-time SQLSA versioning, which allows a program to use an SQLSA

structure with the same version as the current SQL/MP software for the system

(available with version 340 or later SQL/MP software)



Converting a C program written for version 1 or version 2 SQL/MP software to use

version 300 (or later) SQL features and data structures

For additional information about version issues, see the SQL/MP Version Management

Guide.