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)ФранцузскийItaliano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for JDBC for Salesforce Driver User's Guide Release 6.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 JDBC for Salesforce Driver
    • What's New in this Release?
    • Requirements
    • Version String Information
    • Data Source and Driver Classes
    • Connection URL
    • Connection Properties
    • Mapping Objects to Tables
    • Data Types
      • getTypeInfo()
    • SQL escape sequences
      • Supported scalar functions
    • DataDirect tools
    • Additional information
    • Contacting Technical Support
  • Getting Started
    • Setting the Classpath
    • Data Source and Driver Classes
    • Connecting Using the DriverManager
      • Passing the Connection URL
      • Testing the Connection
    • Connecting using data sources
      • How Data Sources Are Implemented
      • Creating data sources
        • Example Data Source
      • Calling a data source in an application
      • Testing a data source connection
  • Using the driver
    • Required permissions for Java SE with the standard Security Manager enabled
      • Permissions for establishing connections
      • Granting access to Java properties
      • Granting access to temporary files
      • Permissions for bulk load from a CSV file
    • Connecting from an application
      • Setting the Classpath
      • Connecting Using the JDBC Driver Manager
        • Passing the Connection URL
        • Testing the Connection
      • Connecting using data sources
        • How Data Sources Are Implemented
        • Creating data sources
          • Example Data Source
        • Calling a data source in an application
        • Testing a data source connection
    • Using Connection Properties
      • Required Properties
      • Mapping Properties
      • Authentication Properties
      • Failover Properties
      • Proxy Server Properties
      • Web Service Properties
      • Bulk API Properties
      • Timeout Properties
      • Statement Pooling Properties
      • Additional Properties
    • Connecting Through a Proxy Server
    • Performance Considerations
    • Client-Side Caches
      • Creating a Cache
      • Modifying a Cache Definition
        • Disabling and Enabling a Cache
        • Refreshing Cache Data
      • Dropping a Cache
      • Caching MetaData
    • Catalog Tables
      • SYSTEM_CACHES Catalog Table
      • SYSTEM_CACHE_REFERENCES Catalog Table
      • SYSTEM_REMOTE_SESSIONS Catalog Table
      • SYSTEM_SESSIONS Catalog Table
    • Reports
    • Authentication
      • Configuring user ID/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
    • Data Encryption
      • FIPS (Federal Information Processing Standard)
    • Using Identifiers
    • Failover Support
    • IP Addresses
    • Statement pooling
    • Connection pooling
    • Timeouts
    • Views and Remote/Local Tables
    • Isolation Levels
    • Scrollable cursors
    • Unicode support
    • Error Handling
    • Large Object (LOB) Support
    • Parameter Metadata Support
      • Insert and Update Statements
      • Select Statements
    • ResultSet MetaData Support
    • Rowset Support
    • Auto-Generated Keys Support
    • DataDirect Bulk Load
      • Using a DDBulkLoad Object
        • Exporting data to a CSV file
        • Loading Data from a ResultSet Object
        • Loading Data from a CSV File
        • Specifying the bulk load operation
        • Logging
    • CSV files
      • Bulk load configuration file
      • Bulk load configuration file schema
      • Character set conversions
      • External overflow files
      • Discard file
    • Tracking JDBC calls with DataDirect Spy
      • Enabling DataDirect Spy
        • Using the JDBC DriverManager
        • Using JDBC Data Sources
        • DataDirect Spy attributes
  • Connection Property Descriptions
    • AccessToken
    • ApplyToLabel
    • AuthenticationMethod
    • BulkFetchThreshold
    • BulkLoadAsync
    • BulkLoadBatchSize
    • BulkLoadConcurrencyMode
    • BulkLoadJobSize
    • BulkLoadPollInterval
    • BulkLoadThreshold
    • BulkLoadVersion
    • CatalogOptions
    • ClaimsIssuer
    • ClaimsSubject
    • ClientID
    • ClientSecret
    • ClientTimeZone
    • ConfigOptions
      • AuditColumns (Configuration Option)
      • CustomSuffix (Configuration Option)
      • KeywordConflictSuffix (Configuration Option)
      • MapSystemColumnNames (Configuration Option)
      • NumberFieldMapping (Configuration Option)
      • UppercaseIdentifiers (Configuration Option)
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CreateMap
    • EnableBulkFetch
    • EnableBulkLoad
    • EnablePKChunking
    • FetchSize
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • InValuesLimit
    • JavaDoubleToString
    • JWTCertAlias
    • JWTCertPassword
    • JWTCertStore
    • LogConfigFile
    • LoginTimeout
    • MaxPooledStatements
    • Password
    • PKChunkSize
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • ReadOnly
    • RefreshToken
    • RegisterStatementPoolMonitorMBean
    • SchemaMap
    • SecurityToken
    • ServerName
    • SpyAttributes
    • StmtCallLimit
    • StmtCallLimitBehavior
    • TransactionMode
    • User
    • WSCompressData
    • WSFetchSize
    • WSPoolSize
    • WSRetryCount
    • WSTimeout
  • Troubleshooting
    • Troubleshooting your application
      • Turning On and Off DataDirect Spy Logging
      • DataDirect Spy Log Example
    • Troubleshooting connection pooling
      • Enabling tracing with the setTracing method
      • Pool Manager Trace File Example
    • Troubleshooting statement pooling
      • Generating an export file with the exportStatement method
      • Statement pool export file example
    • Using Java Logging
      • Logging Components
        • JDBC API Logger
        • SQL Engine Logger
        • Web Service Adapter Logger
      • Configuring Logging
        • Using the JVM for Logging
        • Using the Driver for Logging
  • 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: April 26, 2018
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Salesforce 6.0
    • Documentation

The driver provides support for the SQL statements and the SQL extensions described in this section. 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
TitleResults for “How to create a CRG?”Also Available inAlert