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

Progress DataDirect Connect Series for JDBC User's Guide Release 5.1.4

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 Connect Series for JDBC
    • About the Product Documentation
    • Additional information
    • Contacting Technical Support
  • Getting Started
    • Quick Start Connect
      • Connecting to a Database
        • 1. Setting the Classpath
        • 2. Registering the Drivers
        • 3. Passing the Connection URL
          • URL Formats: DataDirect Connect for JDBC Drivers
          • URL Formats: DataDirect Connect XE for JDBC Drivers
      • Testing the Connection
    • Using the Drivers
      • About the Product
        • Drivers
        • DataDirect Test
        • DataDirect Spy
        • DataDirect Connection Pool Manager
        • J2EE Connector Architecture Resource Adapters
          • Using Resource Adapters with an Application Server
          • Using Resource Adapters from an Application
          • Security Permissions for Resource Adapters
      • Using Connection Properties
        • Providing Connection Information
        • Optimizing Performance
      • Connecting Using the JDBC Driver Manager
        • Registering the Drivers
        • Specifying Connection URLs
          • URL Format: DataDirect Connect for JDBC
          • URL Format: DataDirect Connect XE for JDBC
      • Connecting Using Data Sources
        • How Data Sources Are Implemented
        • Creating Data Sources
        • Calling a Data Source in an Application
      • Using IP Addresses
      • Testing Connections
      • Required Permissions for the Java Platform
        • Permissions for Establishing Connections
        • Granting Access to Java Properties
        • Granting Access to Temporary Files
        • Granting Access to an Oracle tnsnames.ora File
        • Permissions for Kerberos Authentication
          • DB2 Kerberos Permissions
          • Microsoft SQL Server
          • Oracle
          • Sybase
          • Apache Hive Kerberos Permissions
        • Permissions for Bulk Load from a CSV File
      • Unicode Support
      • Error Handling
        • Driver Errors
        • Database Errors
    • Advanced Features
      • Using Failover
      • Using Client Information
      • Using Security
        • Authentication
        • Data Encryption Across the Network
          • SSL Encryption
            • SSL Server Authentication
            • SSL Client Authentication (DB2, MySQL, and Oracle)
      • Using Connection Pooling
      • Using Statement Pooling
      • Using 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
          • Logging
        • Using Bulk Load for Batch Inserts
      • Using CSV Files
        • Bulk Load Configuration File
        • Bulk Load Configuration File Schema
          • Verifying the Bulk Load Configuration File for Database Connections
        • Character Set Conversions
        • External Overflow Files
        • Discard File
  • DataDirect Connect Drivers
    • DB2 Driver
      • Data Source and Driver Classes
      • Connection URL
      • J2EE Connector Architecture Resource Adapter Class
      • Connection Properties
        • AccountingInfo
        • AddToCreateTable
        • AllowImplicitResultSetCloseForXA
        • AlternateID
        • AlternateServers
        • ApplicationName
        • AuthenticationMethod
        • BatchPerformanceWorkaround
        • BulkLoadBatchSize
        • CatalogIncludesSynonyms
        • CatalogOptions
        • CatalogSchema
        • CharsetFor65535
        • ClientHostName
        • ClientUser
        • CodePageOverride
        • ConcurrentAccessResolution
        • ConnectionRetryCount
        • ConnectionRetryDelay
        • ConvertNull
        • CreateDefaultPackage
        • CryptoProtocolVersion
        • CurrentFunctionPath
        • CurrentQueryOptimization
        • Database
        • DatabaseName
        • DynamicSections
        • EnableCancelTimeout
        • EncryptionMethod
        • FailoverGranularity
        • FailoverMode
        • FailoverPreconnect
        • Grantee
        • GrantExecute
        • GSSPluginName
        • GSSPluginObject
        • HostNameInCertificate
        • ImportStatementPool
        • InitializationString
        • InsensitiveResultSetBufferSize
        • JavaDoubleToString
        • JDBCBehavior
        • KeepAlive
        • KeyPassword
        • KeyStore
        • KeyStorePassword
        • LoadBalancing
        • LobStreamingProtocol
        • LocationName
        • LoginTimeout
        • LongDataCacheSize
        • MaxPooledStatements
        • MaxStatements
        • OptimizationProfile
        • OptimizationProfileToFlush
        • PackageCollection
        • PackageOwner
        • Password
        • PortNumber
        • ProgramID
        • ProxyHost
        • ProxyPassword
        • ProxyPort
        • ProxyUser
        • QueryTimeout
        • RandomGenerator
        • RegisterStatementPoolMonitorMBean
        • ReplacePackage
        • ResultSetMetaDataOptions
        • SecureRandomAlgorithm
        • SendStreamAsBlob
        • ServerName
        • SpyAttributes
        • StripNewlines
        • TrustStore
        • TrustStorePassword
        • UseCurrentSchema
        • User
        • ValidateServerCertificate
        • WithHoldCursors
        • XMLDescribeType
      • Performance Considerations
      • DB2 Packages
        • Creating DB2 Packages Using the Package Manager
        • Creating DB2 Packages Using Connection Properties
          • Example: DB2 for Linux/UNIX/Windows
          • Example: DB2 for z/OS and i
        • Creating DB2 Packages Using Package Creation List Files
        • Copying the DB2 Packages (z/OS and i)
      • Data Types
        • DB2 Driver getTypeInfo()
      • Returning and Inserting/Updating XML Data
        • Returning XML Data
          • Character Data
          • Binary Data
        • Inserting/Updating XML Data
          • Character Data
          • Binary Data
      • Support for DB2 pureScale
      • Authentication
        • Using the AuthenticationMethod Property
        • Configuring User ID/Password Authentication
        • Configuring Random Number Generator Secure Seeding
        • Configuring Kerberos Authentication
          • Product Requirements for Kerberos
          • Configuring the Driver
          • Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
        • Configuring Client Authentication
        • Configuring GSS Plug-in Authentication
          • Implementing the DB2GSSPluginClient class
      • Data Encryption
        • Configuring DB2-Specific Encryption
        • Configuring SSL Encryption
      • Proxy server
      • Non-Default Schemas for Catalog Methods
      • Choosing a Db2 optimization class
      • Reauthentication
      • Client Information for Connections
      • DB2 Workload Manager (WLM)
        • WLM attributes for DB2 V9.5 and higher
        • WLM attributes for DB2 for z/OS
      • SQL Escape Sequences
      • Isolation Levels
      • Using Scrollable Cursors
      • DB2 for Linux, UNIX, Windows Stored Procedure Cursor Type OUT Parameters
      • JTA Support
      • Large Object (LOB) Support
      • Batch Inserts and Updates
      • Parameter Metadata Support
        • Insert and Update Statements
        • Select Statements
        • Stored Procedures
      • ResultSet Metadata Support
      • Rowset Support
      • Auto-Generated Keys Support
      • Configuring Failover
        • Specifying Primary and Alternate Servers
        • Specifying Connection Retry
      • Failover Properties
      • Configuring Bulk Load
      • TCP KeepAlive support
    • MySQL Driver
      • Data Source and Driver Classes
      • Connection URL
      • J2EE Connector Architecture Resource Adapter Class
      • Connection Properties
        • AccountingInfo
        • AlternateServers
        • ApplicationName
        • BulkLoadBatchSize
        • CatalogOptions
        • ClientHostName
        • ClientUser
        • CodePageOverride
        • ConnectionRetryCount
        • ConnectionRetryDelay
        • ConvertNull
        • CryptoProtocolVersion
        • Database
        • DatabaseName
        • EncryptionMethod
        • FailoverGranularity
        • FailoverMode
        • FailoverPreconnect
        • HostNameInCertificate
        • ImportStatementPool
        • InitializationString
        • InOrderColumnAccess
        • InsensitiveResultSetBufferSize
        • InteractiveClient
        • JavaDoubleToString
        • JDBCBehavior
        • KeyPassword
        • KeyStore
        • KeyStorePassword
        • LoadBalancing
        • LobCommandSize
        • LoginTimeout
        • MaxPooledStatements
        • MaxStatements
        • Password
        • PortNumber
        • ProgramID
        • ProxyHost
        • ProxyPassword
        • ProxyPort
        • ProxyUser
        • QueryTimeout
        • RegisterStatementPoolMonitorMBean
        • ResultSetMetaDataOptions
        • ServerName
        • SpyAttributes
        • TreatBinaryAsChar
        • TrustStore
        • TrustStorePassword
        • User
        • ValidateServerCertificate
      • Performance Considerations
      • Data Types
        • MySQL Driver getTypeInfo()
      • Data Encryption
        • FIPS (Federal Information Processing Standard)
      • Proxy server
      • Client Information for Connections
      • SQL Escape Sequences
      • Isolation Levels
      • Using Scrollable Cursors
      • JTA Support
      • Large Object (LOB) Support
      • Parameter Metadata Support
        • Insert and Update Statements
        • Select Statements
        • Stored Procedures
      • ResultSet MetaData Support
      • Rowset Support
      • Auto-Generated Keys Support
      • Configuring Failover
        • Specifying Primary and Alternate Servers
        • Specifying Connection Retry
        • Failover Properties
      • Configuring Bulk Load
    • Oracle Driver
      • Data Source and Driver Classes
      • Connection URL
      • J2EE Connector Architecture Resource Adapter Class
      • Connection Properties
        • AccountingInfo
        • Action
        • AlternateServers
        • ApplicationName
        • AuthenticationMethod
        • BatchPerformanceWorkaround
        • BulkLoadBatchSize
        • BulkLoadOptions
        • CatalogOptions
        • ClientHostName
        • ClientID
        • ClientUser
        • CodePageOverride
        • CommitBehavior
        • ConnectionRetryCount
        • ConnectionRetryDelay
        • ConvertNull
        • CryptoProtocolVersion
        • Database
        • DatabaseName
        • DataIntegrityLevel
        • DataIntegrityTypes
        • EditionName
        • EnableBulkLoad
        • EnableCancelTimeout
        • EnableServerResultCache
        • EncryptionLevel
        • EncryptionMethod
        • EncryptionTypes
        • FailoverGranularity
        • FailoverMode
        • FailoverPreconnect
        • FetchTSWTZasTimestamp
        • HostNameInCertificate
        • ImportStatementPool
        • InitialColumnBufferSize
        • InitializationString
        • InsensitiveResultSetBufferSize
        • JavaDoubleToString
        • JDBCBehavior
        • KeyPassword
        • KeyStore
        • KeyStorePassword
        • LoadBalancing
        • LoadLibraryPath
        • LOBPrefetchSize
        • LoginTimeout
        • MaxPooledStatements
        • MaxStatements
        • Module
        • NewPassword
        • Password
        • PortNumber
        • ProgramID
        • QueryTimeout
        • RandomGenerator
        • RegisterStatementPoolMonitorMBean
        • ReportRecycleBin
        • ResultSetMetaDataOptions
        • SDUSize
        • SecureRandomAlgorithm
        • SendFloatParametersAsString
        • ServerName
        • ServerType
        • ServiceName
        • SID
        • SpyAttributes
        • StringParamsMustMatchCharColumns
        • SupportBinaryXML
        • SupportLinks
        • SysLoginRole
        • TNSNamesFile
        • TNSServerName
        • TrustStore
        • TrustStorePassword
        • User
        • ValidateServerCertificate
        • WireProtocolMode
      • Performance Considerations
      • Support for Oracle RAC
      • Using tnsnames.ora Files
        • Connecting to the Database
        • Configuring the tnsnames.ora File
        • Connecting to Oracle Instances Running in Restricted Mode
      • Data Types
        • Using Extended Data Types
        • Using Date/Time Data Types
          • Date/Time Session Parameters
            • TIMESTAMP Data Type
            • TIMESTAMP WITH LOCAL TIME ZONE Data Type
            • TIMESTAMP WITH TIME ZONE Data Type
        • Using Collection Data Types
          • VARRAY/TABLE
          • OBJECT
        • Oracle Driver getTypeInfo()
      • Returning and Inserting/Updating XML Data
        • Returning XML Data
        • Inserting/Updating XML Data
        • REF CURSOR Data Type
      • Authentication
        • Using the AuthenticationMethod Property
        • Configuring User ID/Password Authentication
        • Configuring Kerberos Authentication
          • Product Requirements
          • Configuring the Driver
          • Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
        • Configuring NTLM Authentication
          • Product Requirements
          • Configuring the Driver
        • Configuring Client Authentication
        • Oracle Wallet SSL Authentication
      • Data Encryption and Data Integrity
        • Configuring SSL Encryption
        • Implementing Oracle Advanced Security
        • Configuring Random Number Generator Secure Seeding
        • Using Oracle Wallet as a Keystore
      • Reauthentication
      • Client Information for Connections
      • SQL Escape Sequences
      • Isolation Levels
      • Using Scrollable Cursors
      • JTA Support
      • Batch Inserts and Updates
      • Parameter Metadata Support
        • Insert and Update Statements
        • Select Statements
        • Stored Procedures
      • ResultSet MetaData Support
      • Executing Insert/Update/Delete Statements with a Returning Clause
      • Rowset Support
      • Auto-Generated Keys Support
      • Configuring Failover
        • Specifying Primary and Alternate Servers
        • Specifying Connection Retry
      • Failover Properties
      • Configuring Bulk Load
        • Bulk Load Limitations
    • Progress OpenEdge Driver
      • Data Source and Driver Classes
      • Connection URL
      • Connection Properties
        • AlternateServers
        • CatalogOptions
        • ConnectionRetryCount
        • ConnectionRetryDelay
        • ConvertNull
        • CryptoProtocolVersion
        • Database
        • DatabaseName
        • EncryptionMethod
        • FailoverGranularity
        • FailoverMode
        • FailoverPreconnect
        • HostNameInCertificate
        • ImportStatementPool
        • InitializationString
        • InsensitiveResultSetBufferSize
        • JavaDoubleToString
        • JDBCBehavior
        • LoadBalancing
        • LoginTimeout
        • MaxPooledStatements
        • MaxStatements
        • Password
        • PortNumber
        • QueryTimeout
        • RegisterStatementPoolMonitorMBean
        • ServerName
        • SpyAttributes
        • TrustStore
        • TrustStorePassword
        • User
        • ValidateServerCertificate
      • Performance Considerations
      • Data Types
        • Progress OpenEdge Driver getTypeInfo()
      • Data Encryption
      • Client Information for Connections
      • SQL Escape Sequences
      • Isolation Levels
      • Using Scrollable Cursors
      • JTA Support
      • Parameter Metadata Support
        • Insert and Update Statements
        • Select Statements
        • Stored Procedures
      • ResultSet MetaData Support
      • Rowset Support
      • Blob and Clob Searches
      • Configuring Failover
        • Specifying Primary and Alternate Servers
        • Using the AlternateServers Property
        • Specifying Connection Retry
      • Failover Properties
    • Microsoft SQL Server Driver
      • Data Source and Driver Classes
      • Connection URL
      • J2EE Connector Architecture Resource Adapter Class
      • Connection Properties
        • AccountingInfo
        • AlternateServers
        • AlwaysReportTriggerResults
        • ApplicationIntent
        • ApplicationName
        • AuthenticationMethod
        • BulkLoadBatchSize
        • BulkLoadOptions
        • CatalogOptions
        • ClientHostName
        • ClientUser
        • CodePageOverride
        • ConnectionRetryCount
        • ConnectionRetryDelay
        • ConvertNull
        • CryptoProtocolVersion
        • Database
        • DatabaseName
        • DateTimeInputParameterType
        • DateTimeOutputParameterType
        • DescribeParameters
        • DescribeInputParameters
        • DescribeOutputParameters
        • Domain
        • EnableBulkLoad
        • EnableCancelTimeout
        • EncryptionMethod
        • FailoverGranularity
        • FailoverMode
        • FailoverPreconnect
        • FetchTSWTZAsTimestamp
        • FetchTWFSasTime
        • HostNameInCertificate
        • HostProcess
        • ImportStatementPool
        • InitializationString
        • InsensitiveResultSetBufferSize
        • JavaDoubleToString
        • JDBCBehavior
        • LoadBalancing
        • LoadLibraryPath
        • LoginTimeout
        • LongDataCacheSize
        • MaxPooledStatements
        • MaxStatements
        • NetAddress
        • PacketSize
        • Password
        • PortNumber
        • ProgramID
        • ProgramName
        • QueryTimeout
        • ReceiveStringParameterType
        • RegisterStatementPoolMonitorMBean
        • ResultSetMetaDataOptions
        • SelectMethod
        • SendStringParametersAsUnicode
        • ServerName
        • SnapshotSerializable
        • SpyAttributes
        • StringInputParameterType
        • StringOutputParameterType
        • SuppressConnectionWarnings
        • TransactionMode
        • TruncateFractionalSeconds
        • TrustStore
        • TrustStorePassword
        • User
        • UseServerSideUpdatableCursors
        • ValidateServerCertificate
        • WSID
        • XATransactionGroup
        • XMLDescribeType
      • Performance Considerations
      • Connecting to Named Instances
      • Data Types
        • SQL Server Driver getTypeInfo()
      • Returning and Inserting/Updating XML Data
        • Returning XML Data
        • Character Data
        • Binary Data
        • Inserting/Updating XML Data
        • Character Data
        • Binary Data
      • Authentication
        • Using the AuthenticationMethod Property
        • Configuring SQL Server Authentication
        • Configuring Azure Active Directory Authentication
        • Configuring Kerberos Authentication
          • Product Requirements
          • Configuring the Driver
          • Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
        • Configuring NTLM Authentication
          • Product Requirements
          • Configuring the Driver Not Specifying User Credentials (Windows Only)
          • Configuring the Driver: Specifying User Credentials
      • Data Encryption
        • Using SSL with Microsoft SQL Server
        • Configuring SSL Encryption
      • DML with Results (Microsoft SQL Server 2005 and Higher)
      • Reauthentication
      • Client Information for Connections
      • SQL Escape Sequences
      • Isolation Levels
      • Using the Snapshot Isolation Level
      • Using Scrollable Cursors
      • Server-Side Updatable Cursors
      • JTA Support: Installing Stored Procedures
      • Distributed Transaction Cleanup
        • Transaction Timeout
        • Explicit Transaction Cleanup
      • Large Object (LOB) Support
      • Batch Inserts and Updates
      • Parameter Metadata Support
        • Insert, Update, and Delete Statements
        • Select Statements
        • Stored Procedures
      • ResultSet MetaData Support
      • Rowset Support
      • Auto-Generated Keys Support
      • Null Values
      • Configuring Failover
        • Specifying Primary and Alternate Servers
        • Specifying Connection Retry
      • Failover Properties
      • Configuring Bulk Load
    • Sybase Driver
      • Data Source and Driver Classes
      • Connection URL
      • J2EE Connector Architecture Resource Adapter Class
      • Connection Properties
        • AccountingInfo
        • AlternateServers
        • ApplicationName
        • AuthenticationMethod
        • BatchPerformanceWorkaround
        • BulkLoadBatchSize
        • CatalogOptions
        • ClientHostName
        • ClientUser
        • CodePageOverride
        • ConnectionRetryCount
        • ConnectionRetryDelay
        • ConvertNull
        • CryptoProtocolVersion
        • Database
        • DatabaseName
        • EnableBulkLoad
        • EnableCancelTimeout
        • EncryptionMethod
        • ErrorBehavior
        • FailoverGranularity
        • FailoverMode
        • FailoverPreconnect
        • FetchTWFSasTime
        • HostNameInCertificate
        • ImportStatementPool
        • InitializationString
        • InsensitiveResultSetBufferSize
        • JavaDoubleToString
        • JDBCBehavior
        • LoadBalancing
        • LoginTimeout
        • LongDataCacheSize
        • MaxPooledStatements
        • MaxStatements
        • PacketSize
        • Password
        • PortNumber
        • PrepareMethod
        • ProgramID
        • QueryTimeout
        • RegisterStatementPoolMonitorMBean
        • ResultSetMetaDataOptions
        • SelectMethod
        • ServerName
        • ServicePrincipalName
        • SpyAttributes
        • TransactionMode
        • TrustStore
        • TrustStorePassword
        • UseAlternateProductInfo
        • User
        • ValidateServerCertificate
      • Performance Considerations
      • Data Types
        • Sybase Driver getTypeInfo()
      • Authentication
        • Using the AuthenticationMethod Property
        • Configuring User ID/Password Authentication
        • Configuring Kerberos Authentication
          • Product Requirements
          • Configuring the Driver
          • Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
      • Data Encryption
        • FIPS (Federal Information Processing Standard)
      • Client Information for Connections
      • SQL Escape Sequences
      • Isolation Levels
      • Using Scrollable Cursors
      • Large Object (LOB) Support
      • Batch Inserts and Updates
      • Parameter Metadata Support
      • ResultSet MetaData Support
      • Rowset Support
      • Auto-Generated Keys Support
      • Null Values
      • Configuring Failover
        • Specifying Primary and Alternate Servers
        • Specifying Connection Retry
      • Failover Properties
      • Configuring Bulk Load
      • JTA Support
  • DataDirect Connect XE Drivers
    • The Driver for Apache Hive
      • Data Source and Driver Classes
      • Connection URL
      • Connection Properties
        • AccountingInfo
        • ApplicationName
        • AuthenticationMethod
        • BatchMechanism
        • ClientHostName
        • ClientUser
        • ConnectionRetryCount
        • ConnectionRetryDelay
        • ConvertNull
        • CryptoProtocolVersion
        • Database
        • DatabaseName
        • EnableCancelTimeout
        • EncryptionMethod
        • HostNameInCertificate
        • ImportStatementPool
        • InitializationString
        • InsensitiveResultSetBufferSize
        • JavaDoubleToString
        • KeyPassword
        • KeyStore
        • KeyStorePassword
        • LoginTimeout
        • MaxPooledStatements
        • MaxStatements
        • Password
        • PortNumber
        • ProgramID
        • QueryTimeout
        • RegisterStatementPoolMonitorMBean
        • RemoveColumnQualifiers
        • ServerName
        • ServicePrincipalName
        • SpyAttributes
        • StringDescribeType
        • TransactionMode
        • TrustStore
        • TrustStorePassword
        • UseCurrentSchema
        • User
        • ValidateServerCertificate
        • WireProtocolVersion
      • Performance Considerations
      • Data Types
        • Driver for Apache Hive getTypeInfo()
      • Authentication
        • Using the AuthenticationMethod Property
        • Configuring User ID/Password Authentication
        • Configuring the Driver for Kerberos Authentication
          • Product Requirements
          • The JAAS Login Configuration File
          • The krb5.conf File
          • Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
          • Obtaining a Kerberos Ticket Granting Ticket
          • Kerberos SASL-QOP
      • Data Encryption
      • Views
      • SQL Escape Sequences
      • Isolation Levels
      • Using Scrollable Cursors
      • JTA Support
      • Large Object (LOB) Support
      • Batch Inserts
      • Parameter Metadata Support
        • Insert and Update Statements
        • Select Statements
        • Stored Procedures
      • ResultSet Metadata Support
      • Rowset Support
      • Auto-Generated Keys Support
      • Restrictions for Apache Hive Functionality
    • Salesforce Driver
      • Data Source and Driver Classes
      • Version String Information
      • Connection URL
      • Connection Properties
        • BulkLoadAsync
        • BulkLoadBatchSize
        • BulkLoadConcurrencyMode
        • BulkLoadPollInterval
        • BulkLoadThreshold
        • CatalogOptions
        • ConfigOptions
        • ConnectionRetryCount
        • ConnectionRetryDelay
        • ConvertNull
        • CreateDB
        • Database
        • DatabaseName
        • EnableBulkLoad
        • FetchSize
        • ImportStatementPool
        • InitializationString
        • InsensitiveResultSetBufferSize
        • JavaDoubleToString
        • LogConfigFile
        • LoginTimeout
        • MaxPooledStatements
        • MaxStatements
        • Password
        • ProxyHost
        • ProxyPassword
        • ProxyPort
        • ProxyUser
        • ReadOnly
        • RefreshDirtyCache
        • RefreshSchema
        • RegisterStatementPoolMonitorMBean
        • SecurityToken
        • ServerName
        • StmtCallLimit
        • StmtCallLimitBehavior
        • TransactionMode
        • User
        • WSCompressData
        • WSFetchSize
        • WSRetryCount
        • WSTimeout
      • Performance Considerations
      • Data Types
        • Salesforce Driver getTypeInfo()
      • Mapping Objects to Tables
      • 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
      • Timeouts
      • Views and Remote/Local Tables
      • Using Identifiers
      • Database Configuration File
        • <Database>
        • <User>
        • <UseSchema>
        • <Schema>
        • <ConfigOptions>
        • <SessionOptions>
      • Mapping Objects to Tables
      • Reports
      • Connecting Through a Proxy Server
      • Data Encryption
      • SQL Escape Sequences
      • Isolation Levels
      • Using Scrollable Cursors
      • JTA Support
      • Large Object (LOB) Support
      • Parameter Metadata Support
      • ResultSet MetaData Support
      • Rowset Support
      • Auto-Generated Keys Support
      • Configuring Bulk Load
        • Specifying the Bulk Load Operation
        • Using Bulk Load for Single Inserts/Updates/Deletes
  • Supported SQL Statements and Extensions
    • Supported SQL Statements and Extensions for the Driver for Apache Hive
      • Data Definition Language (DDL)
      • Insert
      • Selecting Data With the Driver
        • Select List
          • Between Clause
          • Column Name Qualification
        • From Clause
        • Group By Clause
        • Having Clause
        • Order By Clause
        • For Update Clause
        • Set Operators
        • Subqueries
      • SQL Expressions
        • Constants
        • Numeric Operators
        • Character Operator
        • Relational Operators
        • Logical Operators
        • Functions
      • Restrictions
    • Supported SQL Statements and Extensions for the Salesforce Driver
      • 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
      • Checkpoint
      • 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 Schema (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
      • Set Checkpoint Defrag
      • Set Logsize
      • Update
      • SQL Expressions
        • Column Names
        • Literals
          • Character String Literals
          • Integer Literals
          • Numeric Literals
          • Binary Literals
          • Date/Time 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: May 18, 2020
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • IBM Db2 5.1
    • MySQL 5.1
    • Progress OpenEdge 5.1
    • SAP Sybase 5.1
    • Documentation

This part includes information on supported SQL statements and extensions for the Apache Hive and Salesforce drivers.

Contents
  • Supported SQL Statements and Extensions for the Driver for Apache Hive
  • Supported SQL Statements and Extensions for the Salesforce Driver
TitleResults for “How to create a CRG?”Also Available inAlert