SQL/MP Programming Manual for COBOL

Introduction

HP NonStop SQL/MP Programming Manual for COBOL—529758-003

1-7

SQL/MP Version Management

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

The initial PVUs were version 1 (C10 and C20) and version 2 (C30). Version 300 of

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

revision (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 315 might be 320, 325, and 340.

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 SQL/MP software version 2 and 315 but is not compatible with version 1 software.

The version information in this manual includes these topics:



Using compatible versions of the COBOL85 compiler, NMCOBOL compiler,

SQL compiler, and SQL executor to compile and execute 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



Converting a COBOL program written for version 1 or version 2 SQL/MP software

to use version 300 (or later) SQL features and data structures



Planning for future PVUs of SQL/MP

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

Guide.

COBOL in the Open System (OSS)

Environment

SQL/MP software supports the development of COBOL programs in the OSS

environment as well as in the Guardian environment. In the OSS environment, you can

code a COBOL program with a text editor such as vi and then use one of these HP

COBOL compilers:



cobol utility to invoke the COBOL85 compiler, Binder program, Accelerator, and

SQL compiler. (The cobol utility is described in Section 6, Explicit Program

Compilation.)



nmcobol utility to invoke the NMCOBOL compiler, ld or nld linker, and SQL

compiler on a TNS/R system