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

UNIX/Linux environment variables

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

UNIX/Linux environment variables

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

The following topics guide you through setting the environment variables for UNIX/Linux platforms. You must set these environment variables before connecting with your driver.

Contents
  • Library search path
  • ODBCINI
  • ODBCINST
  • DD_INSTALLDIR
  • The Test Loading Tool
TitleResults for “How to create a CRG?”Also Available inAlert