ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Table Of Contents
Contents
HP NonStop ODBC/MX Driver for Windows691126-002
iii
6. ODBC/MX Messages
SQL/MP Data Types and ODBC/MX Equivalents 5-13
Microsoft Escape Clauses 5-13
Stored Procedures 5-14
Transactions and Cursor Behavior with Multiple Statements 5-15
Timestamp Values with Fraction 5-15
SQL Interval Value Insertion Property 5-21
Datetime Retrieval Property 5-24
6. ODBC/MX Messages
ODBC/MX Driver Error Codes 6-1
ODBC/MX Client Messages 6-1
Glossary
Index
Figures
Figure 1-1. Connection Data Flow 1-3
Figure 3-1. ODBC/MX Data Source Configuration 3-5
Figure 5-1. Data source configuration screen for SQL Interval Value Insertion 5-22
Figure 5-2. Data source configuration screen for SQL Datetime Retrieval 5-24
Tables
Table 1-1. Release Considerations and Restrictions 1-8
Table 5-1. Connecting to a Data Source 5-2
Table 5-2. Obtaining Information About a Driver and Data Source 5-2
Table 5-3. Setting and Retrieving Driver Attributes 5-3
Table 5-4. Setting and Retrieving Descriptor Fields 5-3
Table 5-5.
Preparing SQL Requests 5-3
Table 5-6. Submitting SQL Requests 5-4
Table 5-7. Retrieving Results and Information About Results 5-4
Table 5-8.
Obtaining Information About a Data Source’s System Tables 5-5
Table 5-9.
Terminating a Statement 5-6
Table 5-10. Terminating a Connection 5-7
Table 5-11.
Numeric Functions 5-7
Table 5-12.
String Functions 5-8
Table 5-13.
Time and Date Functions 5-9
Table 5-14.
System Functions 5-10
Table 5-15. ODBC Data Types 5-10
Table 5-16.
Behavior of Unsigned Data Types 5-12