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 SQL engine server 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 SQL engine server 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

The following sections describe how to configure, start, and stop the SQL engine server on UNIX and Linux platforms.

By default, the driver operates in direct mode by default on UNIX and Linux platforms.
Related Links
  • Configuring and starting the SQL engine server on UNIX/Linux
  • Stopping the SQL engine server
TitleResults for “How to create a CRG?”Also Available inAlert