ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)
Table Of Contents
- HP NonStop ODBC/MX Driver for Windows
- Legal Notices
- Contents
- What’s New in This Manual
- About This Manual
- 1 ODBC/MX Client Overview
- 2 Installation of the ODBC/MX Client
- 3 Configuring Client Data Sources on Windows
- Accessing the Microsoft ODBC Data Source Administrator from a Client Workstation
- Adding New Client Data Sources
- Reconfiguring Client Data Sources
- Configuring Client Data Sources using Connection String
- Configuring Client Data Sources for Update Operations
- Configuring Driver for IPV6
- Removing Client Data Sources
- Tracing Client Data Sources
- 4 Module File Caching (MFC)
- 5 ODBC/MX Conformance
- ODBC API Functions
- SQL Conformance Level
- SQL Scalar Functions
- ODBC Data Types
- Unsigned Data Types
- Partial Date/Time Values
- SQL/MP Data Types and ODBC/MX Equivalents
- Microsoft Escape Clauses
- Stored Procedures
- Transactions and Cursor Behavior with Multiple Statements
- Timestamp Values with Fraction
- SQL Interval Insertion Property
- SQL Datetime Retrieval Property
- 6 ODBC/MX Messages
- Glossary
- Index

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—691126-002
5-5
ODBC API Functions
SQLExtendedFetch 1.0 Yes Fetches the specified rowset of data
from the result set and returns data
for all bound columns. No bookmarks
are supported.
SQLSetPos 1.0 Yes Positions a cursor within a fetched
block of data and allows an
application to refresh data in the row
set or to update or delete data in the
result set.
SQLBulkOperations 3.0 No Performs bulk insertions and bulk
bookmark operations, including
update, delete, and fetch by
bookmark.
SQLMoreResults 1.0 Yes Determines whether there are more
result sets available and, if so,
initializes processing for the next
result set.
SQLGetDiagField 3.0 Yes Returns additional diagnostic
information (a single field of the
diagnostic data structure).
SQLGetDiagRec 3.0 Yes Returns additional diagnostic
information (multiple fields of the
diagnostic data structure).
Table 5-8. Obtaining Information About a Data Source’s System
Tables (page1of2)
Function
ODBC
Version
Supported by
ODBC/MX Description
SQLColumnPrivileges 1.0 Yes Returns a list of columns and
associated privileges for one or more
tables
.
SQLColumns 1.0 Yes Returns a list of column names in
specified tables.
SQLForeignKeys 1.0 Yes Returns a list of column names that
make up foreign keys for a specified
table
.
SQLPrimaryKeys 1.0 Yes Returns a list of column names that
make up the primary key for a table.
Note: See the discussion of
SQLPrimaryKeys in SQLPrimaryKeys
Function on page 1-9.
Table 5-7. Retrieving Results and Information About Results (page 2 of 2)
Function
ODBC
Version
Supported by
ODBC/MX Description










