SQL/MP Programming Manual for COBOL85

Introduction

HP NonStop SQL/MP Programming Manual for COBOL85—429326-004

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, 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

The NonStop OS offers two operating environments:

•

Guardian environment

•

Open System Services (OSS) environment

Open System Services provides industry-standard application program interfaces

(APIs) and utilities to enable you to quickly and easily port existing applications to

NonStop systems.

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 the cobol utility to