Call Level Interface Guide and Reference

Appendix A. Programming Hints and Tips

This section provides some hints and tips to help improve DB2 CLI and ODBC application performance and portability.

• Setting Common Connection Attributes

• Setting Common Statement Attributes

• Comparing Binding and SQLGetData

• Increasing Transfer Efficiency

• Limiting Use of Catalog Functions

• Using Column Names of Function Generated Result Sets

• Loading DB2 CLI Specific Functions From ODBC Applications

• Making use of Dynamic SQL Statement Caching

• Optimizing Insertion and Retrieval of Data

• Optimizing for Large Object Data

• Case Sensitivity of Object Identifiers

• Using SQLDriverConnect Instead of SQLConnect

• Implementing an SQL Governor

[ DB2 List of Books | Search the DB2 Books ]