Guidelines for avoiding common problems

To avoid common problems in Db2 ODBC initialization files, large result sets, and distinct types, adhere to the ODBC guidelines.

Check the Db2 ODBC initialization file
You need to follow several guidelines to ensure that the Db2 ODBC initialization file is free from problems.
Limit the number of rows that an application can fetch
If a result set is too large, it might cause problems for the application. You can follow guidelines to reduce errors.
Cast parameter markers to distinct types or distinct types to source types
When you use a distinct-type parameter in the predicate of a query statement, you must use a CAST function. You can cast either the parameter marker to a distinct type, or you can cast the distinct type to a source type.

Parent topic: ODBC programming hints and tips