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 Salesforce User's Guide Release 8.0.0

Supported SQL statements and extensions

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 Salesforce Driver
    • What's new in this release?
    • Driver requirements
    • Mapping objects to tables
    • Installing and setting up the driver (Windows)
    • Installing and setting up the driver (UNIX/Linux)
    • Connection string examples
      • User ID and password authentication
      • OAuth 2.0 authentication string
    • Data types
    • Driver specifications
    • Version string information
      • getFileVersionString function
    • 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
      • Windows environment variables
      • UNIX/Linux environment variables
        • Library search path
        • ODBCINI
        • ODBCINST
        • DD_INSTALLDIR
        • The Test Loading Tool
      • UTF-16 applications on UNIX and Linux
    • Configuring data sources with the Configuration Manager
    • Generating connection strings with the Configuration Manager
    • 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
    • Testing connections and queries with the Configuration Manager
    • Password Encryption Tool (UNIX/Linux only)
    • Using a logon dialog box
    • Authentication
      • User ID and password authentication
      • Configuring OAuth 2.0 authentication
        • Registering your application with Salesforce
        • Obtaining the client ID, client secret, and scopes
        • Obtaining access and refresh tokens with Postman
        • Configuring the driver to use OAuth 2.0
        • Configuring the driver to use OAuth 2.0 with JWT grant
    • TLS/SSL encryption
      • Certificates
      • TLS/SSL server authentication
      • TLS/SSL client authentication
    • Proxy server
    • DataDirect connection pooling
    • 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
    • Using Bulk API with SQL statements
      • Summary of options for using the Bulk API with SQL statements
    • Performance considerations
  • Additional features and functionality
    • Identifiers
    • Catalog tables
      • SYSTEM_CACHES catalog table
      • SYSTEM_CACHE_REFERENCES catalog table
      • SYSTEM_REMOTE_SESSIONS catalog table
      • SYSTEM_SESSIONINFO catalog table
      • SYSTEM_SESSIONS catalog table
    • Client-side caches
      • Creating a cache
      • Modifying a cache definition
      • Disabling and enabling a cache
      • Refreshing cache data
      • Dropping a cache
      • Cache metadata
    • Reports
    • Views and remote/local tables
    • Parameter metadata support
      • Insert and Update statements
      • Select statements
  • Using the SQL engine server
    • Configuring server mode using the Configuration Manager
      • Stopping the SQL engine server using the Configuration Manager
    • Configuring the SQL engine server using Java options
      • Stopping the SQL engine server
    • Configuring Java logging for the SQL engine server
  • Connection option descriptions
    • Access Token
    • ApplyToLabel
    • Authentication Method
    • Bulk Fetch Threshold
    • Bulk Load Async
    • Bulk Load Batch Size
    • Bulk Load Concurrency Mode
    • Bulk Load Job Size
    • Bulk Load Poll Interval
    • Bulk Load Threshold
    • Bulk Load Version
    • Claims Issuer
    • Claims Subject
    • Client ID
    • Client Secret
    • Collate With UTF Values
    • Config Options (deprecated)
    • Connection Pooling
    • Connection Reset
    • Connection Retry Delay
    • Connection Retry Count
    • Create Map
    • Data Source Name
    • Description
    • Enable Bulk Fetch
    • Enable Bulk Load
    • Enable Primary Key Chunking for Bulk Select
    • Extended Options
    • Fetch Size
    • Host Name
    • Initialization String
    • IN-values Join Limit
    • Java Double To String
    • JVM Arguments
    • JVM Classpath
    • JVM Path
    • JWT Certificate Alias
    • JWT Certificate Password
    • JWT Certificate Store
    • Load Balance Timeout
    • Log Config File
    • Login Timeout
    • Login Timeout
    • Max Pool Size
    • Min Pool Size
    • Password
    • Primary Key Chunk Size
    • Proxy Host
    • Proxy Password
    • Proxy Port
    • Proxy User
    • Read Only
    • Refresh Schema
    • Refresh Token
    • Report Codepage Conversion Errors
    • Schema Map
    • Security Token
    • Server Port Number
    • Statement Call Limit
    • Statement Call Limit Behavior
    • String Collation Mode
    • SQL Engine Mode
    • SQL Service
    • Transaction Mode
    • User
    • Web Service Fetch Size
    • Web Service Pool Size
    • Web Service Retry Count
    • Web Service Timeout
  • Supported SQL statements and extensions
    • Alter Cache (EXT)
      • Relational caches
    • Alter Index
    • Alter Sequence
    • Alter Session (EXT)
    • Alter Table
      • Altering a remote table
        • Add clause: columns
        • Add clause: constraints
        • Drop clause: columns
      • Altering a local table
        • Add clause: columns
        • Add clause: constraints
        • Drop clause: columns
        • Drop clause: constraints
        • Rename clause
    • Create Cache (EXT)
      • Relational caches
      • Referencing clause
      • 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
      • Creating a remote table
        • Column definition for remote tables
        • Constraint definition for remote tables
        • Foreign Key clause
      • Creating a local table
        • Column definition for local tables
        • Constraint definition for local tables
    • Create View
    • Delete
    • Drop Cache (EXT)
    • Drop Index
    • Drop Sequence
    • Drop Table
    • Drop View
    • Explain Plan
    • Insert
      • Specifying an external ID column
    • Refresh Cache (EXT)
    • Refresh Map (EXT)
    • Select
      • Select clause
        • Aggregate functions
        • From clause
          • 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
    • Update
    • 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

Supported SQL statements and extensions

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
    • Salesforce 8.0
    • Documentation

The Salesforce driver provides support for the SQL statements and the SQL extensions described in this chapter. SQL extensions are denoted by an (EXT) in the topic title.

Contents
  • Alter Cache (EXT)
  • Alter Index
  • Alter Sequence
  • Alter Session (EXT)
  • Alter Table
  • Create Cache (EXT)
  • Create Index
  • Create Sequence
  • Create Table
  • Create View
  • Delete
  • Drop Cache (EXT)
  • Drop Index
  • Drop Sequence
  • Drop Table
  • Drop View
  • Explain Plan
  • Insert
  • Refresh Cache (EXT)
  • Refresh Map (EXT)
  • Select
  • Update
  • SQL expressions
  • Subqueries
Alert