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