Open System Services ODBC/MX Client Driver for SQL/MX Release 3.1 (H06.23+, J06.12+)

Contents
HP NonStop Open System Services ODBC/MX Client Driver for SQL/MX Release 3.1—663857-001
ii
2. Configuring Client Data Source Attributes for
ODBC/MX Connectivity
2. Configuring Client Data Source Attributes for ODBC/MX
Connectivity
Accessing the ODBC/MX Data Source 2-1
Configuring Data Sources 2-2
ODBCDSN File Format 2-3
Example ODBCDSN file 2-7
Adding New Data Sources 2-8
Modifying Data Sources 2-8
Removing Data Sources 2-8
Tracing OSS ODBC/MX Client Driver
2-8
Configure Tracing on a Client Data Source
2-8
Enabling Tracing for OSS ODBC/MX Client Driver 2-9
Disabling Tracing for OSS ODBC/MX Client Driver 2-9
Components of the MX Connectivity Service 2-9
Migration Considerations 2-9
Accessing the ODBCDSN file through environment variable 2-10
3. ODBC/MX Conformance
ODBC API Functions 3-2
SQL Conformance Level 3-7
SQL Scalar Functions 3-7
ODBC Data Types 3-10
Unsigned Data Types 3-11
Partial Date/Time Values
3-12
SQL/MP Data Types and ODBC/MX Equivalents
3-12
Microsoft Escape Clauses
3-13
Stored Procedures 3-14
Transactions and Cursor Behavior with Multiple Statements
3-14
Timestamp Values with Fraction
3-14
4. ODBC/MX Messages
ODBC/MX Driver Error Codes 4-1
ODBC/MX Client Messages 4-1
A. Sample ODBC Application
Compilation and Linking of the Sample ODBC Application A-1
Execution and Testing of Sample ODBC Application A-1