SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-41
Data Definition Language (DDL) Statements
Data Definition Language (DDL) Statements
SQL/MP DDL statements, which create SQL/MP database objects, are not supported
in SQL/MX applications. If your SQL/MP application includes DDL statements and you
intend to keep your SQL/MP database, do not convert the application to NonStop
SQL/MX.
To use SQL/MX DDL statements, which create SQL/MX database objects, see
SQL/MX DDL Statements and Utilities
on page 11-14.
Changes to Embedded SQL Constructs
This subsection discusses differences between NonStop SQL/MP and NonStop
SQL/MX in the use of embedded SQL in C and COBOL programs and explains how to
modify embedded SQL constructs so that they comply with NonStop SQL/MX:
•
Host Variable Declarations on page 10-42
•
Indicator Variables on page 10-44
•
Embedded SQL Statements on page 10-45
•
Dynamic SQL on page 10-47
•
Error Handling on page 10-49
•
Statistics Area on page 10-53
The main differences are in the diagnostics areas for error handling and in the
descriptor areas for dynamic SQL programming. For more information about
embedded SQL/MX statements in C, C++, and COBOL programs, see the
SQL/MX
Programming Guide for C and COBOL.
Table 10-11. SQL/MX and SQL/MP DSL Statements
SQL/MP DSL
Statements
Implemented
in SQL/MX? Comments
GET CATALOG OF
SYSTEM
No Remove this statement from the source code, or
do not convert the application to NonStop
SQL/MX.
GET VERSION No Remove this statement from the source code, or
do not convert the application to NonStop
SQL/MX.
GET VERSION OF
PROGRAM
No Remove this statement from the source code, or
do not convert the application to NonStop
SQL/MX.