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 Oracle Service Cloud User's Guide Release 7.1.6

Configuring the product on UNIX/Linux

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 Oracle Service Cloud Driver
    • What's new in this release?
    • Driver requirements
    • ODBC compliance
    • Version string information
      • getFileVersionString function
    • Support for multiple environments
      • Environment-specific information
        • For Windows users
          • 32-bit drivers
          • 64-bit drivers
          • Setup of the driver
          • Driver file names for Windows
        • For UNIX and Linux users
          • 32-bit drivers
          • 64-bit drivers
          • Setup of the environment and the drivers
          • AIX
          • HP-UX 11 aCC
          • Linux
          • Oracle Solaris
          • Driver file names for UNIX/Linux
    • Data types
      • Retrieving data type information
    • Mapping objects to tables
      • Standard and custom objects
      • Primary objects, sub-objects, and lists of sub-objects
      • Many-to-many relationships
    • SQL support
    • Additional information
    • Troubleshooting
    • Contacting Technical Support
  • Getting started
    • Configuring and connecting on UNIX and Linux
      • Environment configuration
      • Test loading the driver
      • Setting the library path environment variable (UNIX and Linux)
      • Configuring a data source in the system information file
      • Testing the connection
    • Configuring and connecting on Windows
      • Setting the library path environment variable (Windows)
      • Configuring a data source
      • Testing the connection
  • 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
          • 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
        • SQL Engine tab
        • Advanced tab
        • Web Service tab
        • Pooling tab
      • Using a connection string
      • Password Encryption Tool (UNIX/Linux only)
      • Using a logon dialog box
    • Performance considerations
    • Using client-side caches
      • Creating a cache
      • Modifying a cache definition
      • Disabling and enabling a cache
      • Refreshing cache data
      • Dropping a cache
      • Cache metadata
    • Using catalog tables
      • SYSTEM_CACHES catalog table
      • SYSTEM_REMOTE_SESSIONS catalog table
      • SYSTEM_SESSIONINFO catalog table
      • SYSTEM_SESSIONS catalog table
    • Using identifiers
    • Views and remote/local tables
    • Using the database configuration file
      • Database
      • User
      • UseSchema
      • Schema
      • ConfigOptions
      • SessionOptions
    • Using reports
    • Connecting through a proxy server
    • Configuring the SQL engine server
      • Configuring the SQL engine server on Windows
        • Configuring server mode
        • Starting the SQL engine server
        • Stopping the SQL engine server
      • Configuring the SQL engine server on UNIX/Linux
        • Configuring and starting the SQL engine server on UNIX/Linux
        • Stopping the SQL engine server
      • Configuring Java logging for the SQL engine server
    • 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 connection pooling
    • Isolation and lock levels supported
    • Unicode support
    • Binding parameter markers
    • Parameter metadata support
      • Insert and Update statements
      • Select statements
    • "Poor performing query" error message
  • Connection option descriptions
    • Application Using Threads
    • Compress Data
    • Config Options
      • AuditColumns (Config Option)
      • MapCustomNamedIDFields (Config Option)
      • MapSystemColumnNames (Config Option)
      • NamedIDBehavior (Config Option)
      • UppercaseIdentifiers (Config Option)
    • Connection Pooling
    • Connection Reset
    • Create Database
    • Data Source Name
    • Database
    • Description
    • Enable Access Request Header
    • Enable Paging With Order By ID
    • Fetch Size
    • Host Name
    • IANAAppCodePage
    • Initialization String
    • Interface Name
    • JVM Arguments
    • JVM Classpath
    • LoadBalance Timeout
    • Log Config File
    • Login Timeout
    • Managed Objects
    • Max Pool Size
    • Min Long Varchar Size
    • Min Pool Size
    • Oracle Service Cloud Database
    • Password
    • Proxy Host
    • Proxy Port
    • Proxy Password
    • Proxy User
    • Refresh Dirty Cache
    • Report Codepage Conversion Errors
    • Server Port Number
    • SQL Engine Mode
    • Statement Call Limit
    • Statement Call Limit Behavior
    • Transaction Mode
    • User Name
    • Varchar Threshold
    • WSFetchSize
    • WSRetry Count
    • WSTimeout
  • Supported SQL statements and extensions
    • Alter Cache (EXT)
    • Alter Index
    • Alter Sequence
    • Alter Session (EXT)
    • Alter Table
      • Add clause: columns
      • Add clause: constraints
      • Drop clause: columns
      • Drop clause: constraints
      • Rename clause
    • Checkpoint
    • Create Cache (EXT)
      • Refresh Interval clause
      • Initial Check clause
      • Persist clause
      • Enabled clause
      • Call Limit clause
      • Filter clause
    • Create Index
    • Create Sequence
      • Next Value For clause
    • Create Table
      • Column definition for local tables
      • Constraint definition for local tables
    • Create View
    • Drop Cache (EXT)
    • Drop Index
    • Drop Sequence
    • Drop Table
    • Drop View
    • Explain Plan
    • Refresh Cache (EXT)
    • Set Checkpoint Defrag
    • Set Logsize
    • Select
      • Select clause
        • Aggregate functions
        • From clause
          • Outer join escape sequences
          • Join in a From clause
          • Subquery in a From clause
        • Where clause
        • Group By clause
        • Having clause
        • Union operator
        • Intersect operator
        • Except and Minus operators
        • Order By clause
        • Limit clause
    • SQL expressions
      • Column names
      • Literals
        • Character string literals
        • Numeric literals
        • Binary literals
        • Date/Time literals
        • Integer literals
      • Operators
        • Unary operator
        • Binary operator
        • Arithmetic operators
        • Concatenation operator
        • Comparison operators
        • Logical operators
        • Operator precedence
      • Functions
      • Conditions
    • Subqueries
      • IN predicate
      • EXISTS predicate
      • UNIQUE predicate
      • Correlated subqueries
  • Copyright
Table of Contents

Configuring the product on UNIX/Linux

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: October 30, 2020
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Oracle Service Cloud 7.1
    • Documentation

This section contains specific information about using your Progress DataDirect for ODBC driver in the UNIX and Linux environments.

See "Environment-specific information" for additional platform information.

Related Links
  • Environment variables
  • The test loading tool
  • Data source configuration
  • The example application
  • DSN-less connections
  • File data sources
  • UTF-16 applications on UNIX and Linux
Related Links
  • Environment-specific information
TitleResults for “How to create a CRG?”Also Available inAlert