SQL/MP Programming Manual for C

Converting C Programs

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

D-8

Planning for Future PVUs

If you are converting a C program developed for NonStop SQL/MP version 1 or

version 2 software to use version 300 (or later) features and to run on NonStop

SQL/MP version 300 (or later) software, consider making these changes in the

program for compatibility with future NonStop 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 might generate a run-time

error.

If you call any of these procedures, consider modifying the program as follows:

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 pragma and the

INCLUDE SQLDA directive might not be supported in future PVUs.

Consider modifying the 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 the program to use version 300 (or later) SQLDA structures.

Remove the RELEASE1 or RELEASE2 option from the SQL pragma or the INCLUDE

SQLDA directive.

For more information about the INCLUDE STRUCTURES directive, see Section 9,

Error and Status Reporting.

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.