MX Release 3.2.1 (H06.26+, J06.15+)

SQL Scalar Functions..........................................................................................................36

CONVERT Function............................................................................................................38

ODBC Data Types..................................................................................................................38

Unsigned Data Types..............................................................................................................39

Partial Date/Time Values.........................................................................................................40

SQL/MP Data Types and ODBC/MX Equivalents........................................................................40

Microsoft Escape Clauses........................................................................................................41

Stored Procedures...................................................................................................................41

Transactions and Cursor Behavior with Multiple Statements..........................................................41

Timestamp Values with Fraction................................................................................................42

SQL Interval Behaviour property...............................................................................................46

SQL Datetime Retrieval property...............................................................................................48

4 ODBC/MX Messages...............................................................................49

ODBC/MX Driver Error Codes.................................................................................................49

ODBC/MX Client Messages................................................................................................49

A Sample ODBC Application........................................................................53

Compilation and Linking of the Sample ODBC Application..........................................................53

Example A-1. Example for compiling a threaded program.......................................................53

Example A-2. Example for linking a threaded program...........................................................53

Execution and Testing of Sample ODBC Application...................................................................54

Sample ODBC Application Code.........................................................................................54

Sample ODBC Application Code.........................................................................................55

Glossary....................................................................................................61

Index.........................................................................................................62

4 Contents