Connectivity Concepts
This section deals with some of the lesser-used SQL connectivity features. Some of these topics cover configuration options that are probably already set the way you want (e.g., Auto Reconnect), while other topics are advanced and rarely used (e.g., Low Level Table Open).
Topics Covered
- SQL Database Drivers - Client Usage
- Auto Reconnect
- Database Cursors
- Structure Caching
- Selective Column Fetching
- Using SQL Filters (Constraints)
- Low Level Table Open Techniques
- Error Handling
- ODBC Data Sources
- ODBC Escape Sequences
- Create a DB2 Database
- Driver Configuration
- Type Mappings
- The N Prefix in SQL
- Transactions