• Welcome to the Progress DataDirect for ODBC Drivers Reference
•  Troubleshooting
  •  Diagnostic tools
    •  ODBC trace
      • Creating a Trace Log
      •  Enabling Tracing
        • Windows ODBC Administrator
        • macOS iODBC Administrator
        • System information (odbc.ini) file
    • Test loading tool
    • ODBC Test
    • iODBC Demo and iODBC Test
    •  Logging for Java components
      •  Loggers and logging levels
        • Driver to SQL communication logger
        • SQL engine logger
        • Wire protocol adapter logger
      •  Configuring logging
        • Using the JVM
        • Using the driver
    • The example application
    • Other tools
  • Error messages
  •  Troubleshooting
    •  Setup/connection issues
      • Troubleshooting the issue
    •  Interoperability issues
      • Troubleshooting the issue
    • Performance issues
•  Code page values
  • IANAAppCodePage values
  • IBM to IANA code page values
  • Teradata code page values
•  ODBC API and scalar functions
  • API functions
  •  Scalar functions
    • String functions
    • Numeric functions
    • Date and time functions
    • System functions
•  Internationalization, localization, and Unicode
  •  Internationalization and Localization
    • Locale
    • Language
    • Country
    • Variant
  •  Unicode character encoding
    • Background
    • Unicode support in databases
    • Unicode support in ODBC
  •  Unicode and non-Unicode ODBC drivers
    •  Function calls
      • Unicode application with a non-Unicode driver
      • Unicode application with a Unicode driver
    •  Data
      • Unicode driver
      • ANSI driver
    •  Default Unicode mapping
      • Connection attribute for Unicode
  •  Driver Manager and Unicode encoding on UNIX/Linux
    • References
  • Character encoding in the odbc.ini and odbcinst.ini files
•  Designing ODBC Applications for Performance Optimization
  •  Using Catalog Functions
    • Caching Information to Minimize the Use of Catalog Functions
    • Avoiding Search Patterns
    • Using a Dummy Query to Determine Table Characteristics
  •  Retrieving Data
    • Retrieving Long Data
    • Reducing the Size of Data Retrieved
    • Using Bound Columns
    • Using SQLExtendedFetch Instead of SQLFetch
    • Choosing the Right Data Type
  •  Selecting ODBC Functions
    • Using SQLPrepare/SQLExecute and SQLExecDirect
    • Using Arrays of Parameters
    • Using the Cursor Library
  •  Managing Connections and Updates
    • Managing Connections
    • Managing Commits in Transactions
    • Choosing the Right Transaction Model
    • Using Positioned Updates and Deletes
    • Using SQLSpecialColumns
•  Using indexes
  • Introduction
  • Improving row selection performance
  • Indexing multiple fields
  • Deciding which indexes to create
  • Improving join performance
•  Locking and isolation levels
  • Locking
  • Isolation levels
  • Locking modes and levels
• SSL encryption cipher suites
•  DataDirect Bulk Load
  • DataDirect Bulk Load functions
  •  Utility functions
    • GetBulkDiagRec and GetBulkDiagRecW
  •  Export, validate, and load functions
    • ExportTableToFile and ExportTableToFileW
    • ValidateTableFromFile and ValidateTableFromFileW
    • LoadTableFromFile and LoadTableFromFileW
    • Using the TableName parameter with the Salesforce driver
    • SetBulkOperation (Salesforce driver only)
    • GetBulkOperation (Salesforce driver only)
  •  DataDirect Bulk Load statement attributes
    • SQL_BULK_EXPORT_PARAMS
    • SQL_BULK_EXPORT
•  DataDirect Connection Pooling
  • Creating a Connection Pool
  • Adding Connections to a Pool
  • Removing Connections from a Pool
  • Handling Dead Connections in a Pool
  • Connection Pool Statistics
• Threading
• WorkAround options