•  Welcome to the Progress DataDirect for ODBC for Amazon Redshift Wire Protocol Driver
  • What's New in this Release?
  • Conventions Used in This Guide
  • About the Product Documentation
  • Contacting Technical Support
•  Getting Started
  •  Configuring and Connecting on Windows
    • Configuring a Data Source
    • Testing the Connection
  •  Configuring and Connecting on UNIX and Linux
    • Environment Configuration
    • Test Loading the Driver
    • Configuring a Data Source in the System Information File
    • Testing the Connection
  • Accessing Data With Third-Party Applications
•  What Is ODBC?
  • How Does It Work?
  • Why Do Application Developers Need ODBC?
•  About the Amazon Redshift Wire Protocol Driver
  • Driver Requirements
  •  Support for Multiple Environments
    •  Support for Windows Environments
      • 32-Bit Driver
      • 64-Bit Driver
      • Setup of the Driver
      • Driver File Names for Windows
    •  Support for UNIX and Linux Environments
      • 32-Bit Driver
      • 64-Bit Drivers
      • AIX
      • HP-UX 11 aCC
      • Linux
      • Oracle Solaris
      • Setup of the Environment and the Drivers
      • Driver File Names for UNIX/Linux
  • ODBC Compliance
  •  Version String Information
    • getFileVersionString Function
  •  Data Types
    • Retrieving Data Type Information
  • Isolation and Lock Levels Supported
  • Binding Parameter Markers
•  Supported Features
  • Unicode Support
  • Using IP Addresses
  • SQL Support
  • Number of Connections and Statements Supported
•  Using the Driver
  •  Configuring and Connecting to Data Sources
    •  Configuring the Product on UNIX/Linux
      •  Environment Variables
        • Library Search Path
        • ODBCINI
        • ODBCINST
        • DD_INSTALLDIR
      • The Test Loading Tool
      •  Data Source Configuration on UNIX/Linux
        •  Configuration Through the System Information (odbc.ini) File
          • Sample Default odbc.ini File
      • The Example Application
      •  DSN-less Connections
        • Sample odbcinst.ini File
      • File Data Sources
      • UTF-16 Applications on UNIX and Linux
    •  Data Source Configuration through a GUI
      • Advanced Tab
      • Security Tab
      • Failover Tab
      • Pooling Tab
    • Using a Connection String
    • Using a Logon Dialog Box
  • Performance Considerations
  •  Using Failover
    • Connection Failover
    • Extended Connection Failover
    • Select Connection Failover
    • Guidelines for Primary and Alternate Servers
    • Using Client Load Balancing
    • Using Connection Retry
    •  Configuring Failover-Related Options
      • A Connection String Example
      • An odbc.ini File Example
  •  Using Security
    • Data Encryption Across the Network
    •  SSL Encryption
      • Certificates
      • SSL Server Authentication
      • SSL Client Authentication
      • Designating an OpenSSL Library
    • Summary of Security-Related Options
  •  Using 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
    • Configuring Pooling-Related Options
  • Persisting a Result Set as an XML Data File
•  Troubleshooting
  •  Diagnostic Tools
    •  ODBC Trace
      • Creating a Trace Log
      •  Enabling Tracing
        • Windows ODBC Administrator
        • System Information (odbc.ini) File
    • The Test Loading Tool
    • ODBC Test
    • The Example Application
    • Other Tools
  • Error Messages
  •  Troubleshooting
    •  Setup/Connection Issues
      • Troubleshooting the Issue
    •  Interoperability Issues
      • Troubleshooting the Issue
    • Performance Issues
•  Connection Option Descriptions
  • AllowedOpenSSLVersions
  • Alternate Servers
  • Application Using Threads
  • Connection Pooling
  • Connection Reset
  • Connection Retry Count
  • Connection Retry Delay
  • Crypto Protocol Version
  • CryptoLibName
  • Database Name
  • Data Source Name
  • Description
  • Enable SQLDescribeParam
  • Encryption Method
  • Extended Column MetaData
  • Failover Granularity
  • Failover Mode
  • Failover Preconnect
  • Fetch TSWTZ as Timestamp
  • Host Name
  • Host Name In Certificate
  • IANAAppCodePage
  • Initialization String
  • Key Password
  • Key Store
  • Key Store Password
  • Load Balance Timeout
  • Load Balancing
  • Login Timeout
  • Max Char Size
  • Max Pool Size
  • Max Varchar Size
  • Min Pool Size
  • Password
  • Port Number
  • Proxy Host
  • Proxy Mode
  • Proxy Password
  • Proxy Port
  • Proxy User
  • Query Timeout
  • Report Codepage Conversion Errors
  • SSLLibName
  • TCP Keep Alive
  • Transaction Error Behavior
  • Truststore
  • Truststore Password
  • User Name
  • Validate Server Certificate
•  Reference
  •  Code Page Values
    • IANAAppCodePage 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
  • WorkAround Options
  • Threading
•  Glossary
  • application
  • authentication
  • bulk load
  • client load balancing
  • conformance
  • connection pooling
  • connection retry
  • connection string
  • data source
  • driver
  • Driver Manager
  • DSN (Data Source Name)
  • DTC (Distributed Transaction Coordinator)
  • failover
  • index
  • isolation level
  • Kerberos
  • load balancing
  • locking level
  • MTS (Microsoft Transaction Server)
  • NTLM
  • ODBC Administrator
  • OS authentication
  • Performance Tuning Wizard
  • reauthentication
  • SQL Grammar
  • Secure Sockets Layer (SSL)
  • SSL client/server authentication
  • Unicode
  • user ID/password authentication
• Copyright