MX 2.x)

Migrating Applications from NonStop ODBC Server

HP NonStop SQL/MX Connectivity Service Manual—524944-008

A-13

Modifying SQL Statements

NonStop ODBC Server uses Core SQL statements for ODBC connections and T-SQL

statements for DBLib clients. Core SQL language is a subset of the ANSI-92 standard.

ODBC/MX supports all DML SQL statements that are defined in SQL/MX and are

compliant with the ANSI-92 standard. In addition, SQL/MX supports ODBC extensions

for function calls and datetime literals.

ODBC/MX supports all DDL statements as defined in SQL/MX.

Grant and Revoke statements are supported as defined in SQL/MX.

Migrating SQL Server Objects

To migrate T-SQL system table objects, you must define them in the ODBC/MX

environment. The following T-SQL system table names are used by DBLib and have

no ODBC/MX equivalents:

SYSCOLUMNS SYSOBJECTS

SYSDATABASES SYSPROTECTS

SQLSetCursorName SQLSetCursorName Y Y

No equivalent SQLSetDescField Y N

No equivalent SQLSetDescRec Y N

No equivalent SQLSetEnvAttr Y N

No equivalent SQLSetStmtAttr Y N

SQLSetParam SQLBindParameter YY

SQLSetPos SQLSetPos Y Y

* Function names in italics are converted between both versions.

SQLSetScrollOption SQLSetScrollOption N N

SQLSetStmtOption SQLSetStmtAttr Y Y

SQLSpecialColumns SQLSpecialColumns Y Y

SQLStatistics SQLStatistics Y Y

SQLTablePrivileges SQLTablePrivileges Y N

SQLTables SQLTables Y Y

SQLTransact SQLEndTran YY

* Function names in italics are converted between both versions.

Table A-1. ODBC API Mapping Between 2.x and 3.x Versions (page3of3)

ODBC 2.x Calls* ODBC 3.x Calls*

3.x Calls

Supported by

ODBC/MX?

2.x Calls

Supported by

ODBC Server?