SQL/MP Programming Manual for COBOL

Converting COBOL Programs

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

D-8

Planning for Future PVUs

If you are converting a COBOL program developed for SQL/MP version 1 or version 2

software to use version 300 (or later) features and to run on SQL/MP version 300 (or

later) software, consider making these changes in your program for compatibility with

future SQL/MP PVUs.

SQL/MP Version Procedures

The SQLGETOBJECTVERSION, SQLGETCATALOGVERSION, and

SQLGETSYSTEMVERSION system procedures, which return SQL version

information, might not be supported in a future PVU and will return an

“Unresolved External References” error at run time.

If you call any of these procedures, consider modifying your program.

For more information, including the syntax of the GET VERSION statements, see the

SQL/MP Reference Manual.

RELEASE1 and RELEASE2 Options

The RELEASE1 and RELEASE2 options used in the SQL compiler directive and the

INCLUDE SQLDA directive might not be supported in a future PVU.

Consider modifying your program to use the INCLUDE STRUCTURES directive with

the VERSION 1 or VERSION 2 options to generate version 1 or version 2 SQLDA

structures. Or, convert your program to use version 300 (or later) SQLDA structures.

Remove the RELEASE1 or RELEASE2 option from the SQL compiler directive or the

INCLUDE SQLDA directive.

For more information about the INCLUDE STRUCTURES directive, see Using the

INCLUDE STRUCTURES Directive on page 9-1.

Procedure Description of Conversion

SQLGETOBJECTVERSION Convert to the GET VERSION statement, or query the

TABLES.OBJECTVERSION column.

SQLGETCATALOGVERSION Convert to the GET VERSION OF CATALOG statement,

or query the VERSIONS.CATALOGVERSION column.

SQLGETSYSTEMVERSION Convert to the GET VERSION OF SYSTEM statement.