Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for ODBC for Db2 Wire Protocol Driver User's Guide Release 8.0.2

Additional features and functionality

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for ODBC for Db2 Wire Protocol Driver
    • What's new in this release?
    • Driver requirements
    • Installing and setting up the driver (Windows)
    • Installing and setting up the driver (UNIX/Linux)
    • Connection string examples
      • User ID/password authentication
      • Kerberos authentication
      • Connection Failover
      • TLS/SSL client authentication
      • TLS/SSL server authentication
    • Version string information
      • getFileVersionString function
    • Data Types
      • Using the XML Data Type
    • Driver specifications
    • Additional information
    • Troubleshooting
    • Contacting Technical Support
  • Tutorials
    • The Example application
    • Tableau (Windows only)
    • Microsoft Excel (Windows only)
  • Configuring and connecting to data sources
    • Environment settings
      • UNIX/Linux environment variables
        • Library search path
        • ODBCINI
        • ODBCINST
        • DD_INSTALLDIR
        • The Test Loading Tool
      • UTF-16 applications on UNIX and Linux
    • Configuring the driver using the GUI
      • General tab
      • Advanced tab
      • Security tab
      • Modify Bindings tab
      • Failover tab
      • Pooling tab
      • Bulk tab
      • Client Monitoring tab
    • Using a connection string
    • Additional configuration methods for UNIX and Linux
      • Configuration through the system information (odbc.ini) file
        • Sample default odbc.ini file
      • DSN-less connections
        • Sample odbcinst.ini file
      • File data sources
    • Password Encryption Tool (UNIX/Linux only)
    • Using a logon dialog box
    • Authentication
      • User ID/password authentication
      • Kerberos authentication
    • TLS/SSL encryption
      • Certificates
      • TLS/SSL server authentication
        • Using SQL_COPT_INMEMORY_TRUSTSTORECERT
        • Importing root certificates into the Windows certificate store
          • Importing root certificates using Certificate Import Wizard
          • Importing root certificates using a PowerShell script
      • TLS/SSL client authentication
      • Generating TLS/SSL certificates using OpenSSL 3.5-compliant algorithms
      • Designating an OpenSSL library
    • Failover support
      • Configuring failover
      • Guidelines for primary and alternate servers
    • DataDirect Bulk Load
      • Bulk Export and Load Methods
      • Exporting data from a database
      • Bulk loading to a database
      • The bulk load configuration file
        • Bulk load configuration file schema
        • Verification of the bulk load configuration file
      • Sample applications
      • Character set conversions
      • External overflow files
      • Limitations
    • DataDirect connection pooling
    • Performance considerations
  • Additional features and functionality
    • Binding
      • Creating Db2 Packages Using List Files
      • Creating Db2 Packages Manually
    • IBM to IANA code page values
    • Cursor Stability isolation level
    • Stored procedure support
    • Unexpected characters
    • Support for Db2 pureScale
    • Persisting a result set as an XML data file
      • Using the Windows XML Persistence Demo tool
      • Using the UNIX/Linux XML Persistence Demo tool
    • Using arrays of parameters
    • Packet logging
  • Connection option descriptions
    • Accounting Info
    • Add to Create Table
    • Alternate ID
    • Alternate Servers
    • Application Name
    • Application Using Threads
    • Authentication Method
    • Batch Size
    • Bulk Binary Threshold
    • Bulk Character Threshold
    • Catalog Schema
    • Character Set for CCSID 65535
    • Client Host Name
    • Client User
    • Collection
    • Concurrent Access Resolution
    • Connection Pooling
    • Connection Reset
    • Connection Retry Count
    • Connection Retry Delay
    • Crypto Protocol Version
    • CryptoLibName
    • Current Function Path
    • Data Source Name
    • Database Name
    • Default Isolation Level
    • Description
    • Dynamic Sections
    • Enable Bulk Load
    • Enable FIPS
    • Encryption Method
    • Extended Options
    • Failover Granularity
    • Failover Mode
    • Failover Preconnect
    • Fetch Time Stamp With Time Zone as Timestamp
    • Field Delimiter
    • Grant Execute to [check box]
    • Grant Execute to [field]
    • GSS Client Library
    • Host Name In Certificate
    • IANAAppCodePage
    • IP Address
    • Key Password
    • Keystore
    • Key Store Password
    • Load Balance Timeout
    • Load Balancing
    • Location Name
    • Login Timeout
    • Max Pool Size
    • Min Long Varchar Size
    • Min Pool Size
    • OpenSSLConfigFile
    • OpenSSLProviderPath
    • Package Collection
    • Package Name Prefix
    • Package Owner
    • Password
    • Program ID
    • Query Timeout
    • Record Delimiter
    • Report Codepage Conversion Errors
    • SSLLibName
    • TCP Keep Alive
    • TCP Port
    • Trust Store
    • Trust Store Password
    • Use Current Schema for Catalog Functions
    • User Name
    • Validate Server Certificate
    • Varchar Threshold
    • With Hold Cursors
    • XML Describe Type
  • Copyright
Table of Contents

Additional features and functionality

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: August 20, 2021
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • IBM Db2 8.0
    • Documentation

The following section describes additionally supported features and functionality that are specific to the driver.

Contents
  • Binding
  • IBM to IANA code page values
  • Cursor Stability isolation level
  • Stored procedure support
  • Unexpected characters
  • Support for Db2 pureScale
  • Persisting a result set as an XML data file
  • Using arrays of parameters
  • Packet logging
TitleResults for “How to create a CRG?”Also Available inAlert