DB2 ODBC reference information

To use DB2® ODBC effectively, you need to know about differences between ODBC and DB2 ODBC, DB2 ODBC data types, extended scalar functions, SQLSTATEs, deprecated functions. You must also know where to locate example code.

DB2 ODBC and ODBC differences
DB2 ODBC and standard ODBC differ in several ways for their drivers, data types, and isolation levels.
Extended scalar functions
ODBC supports the use of extended scalar functions through vendor escape clauses. Each function can be called by using the escape clause syntax, or by calling the equivalent DB2 function.
SQLSTATE cross reference
SQLSTATEs are returned by the DB2 ODBC application as a diagnostic tool for encountered errors, indicating the cause for these errors.
Data conversion between the application and the database server
Data conversion is possible between C and SQL data types. You need to know the precision, scale, length, and display size of each data type. In addition, you will also need to know how to convert from one data type to the other.
Deprecated ODBC functions
DB2 ODBC supports the ODBC 3.0 standard and all deprecated functions. Use the function replacements where applicable to optimize performance.
Example DB2 ODBC code
You can view example DB2 ODBC code for a sample verification program DSN8O3VP and for a client application APD29 that calls a stored procedure.

Parent topic: Introduction to DB2 ODBC