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

Progress DataDirect Connect Series for ODBC User's Guide Release 7.1.6

SQL Support

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 ODBC
    • What's new in this release?
    • Product Matrix
    • Product Platforms
    • About the Documentation Library
    • Contacting Technical Support
  • Quick Start Connect
    • Configuring and Connecting on Windows
      • Configuring a Data Source
      • Minimum Configuration Requirements (Windows)
      • Testing the Connection
    • Configuring and Connecting on UNIX and Linux
      • Environment Configuration
      • Test Loading the Driver
      • Configuring a Data Source
      • Minimum Configuration Requirements (UNIX/Linux)
      • Testing the Connection
  • Tutorials
    • The Example application
    • Microsoft Excel (Windows only)
  • General Information on Using Connect Drivers
    • About the Product
      • Support for Multiple Environments
    • Environment-Specific Information
      • For Windows Users
        • 32-Bit Drivers
        • 64-Bit Drivers
        • Setup of the Drivers
        • Driver Names
      • For UNIX and Linux Users
        • 32-Bit Drivers
        • 64-Bit Drivers
        • AIX
        • HP-UX 11 aCC
        • Linux
        • Oracle Solaris
        • Setup of the Environment and the Drivers
        • Driver Names
    • Using IP Addresses
    • Binding Parameter Markers
    • Driver Threading Information
    • Version String Information
      • getFileVersionString Function
    • Retrieving Data Type Information
    • Persisting a Result Set as an XML Data File
      • Using the Windows XML Persistence Demo Tool
      • Using the UNIX/Linux XML Persistence Demo Tool
    • Translators
    • Packet logging
  • Advanced Features
    • Using Failover
      • Connection Failover
      • Extended Connection Failover
      • Select Connection Failover
      • Guidelines for Primary and Alternate Servers
      • Using Client Load Balancing
      • Using Connection Retry
      • Summary of Failover-Related Options
        • A Connection String Example
        • An odbc.ini File Example
    • Using Security
      • Authentication
        • Kerberos Authentication
        • NTLM Authentication
        • Summary of Authentication-Related Options
          • Connection String Examples for Configuring Authentication
          • odbc.ini File Examples for Configuring Authentication
      • Data Encryption Across the Network
      • TLS/SSL Encryption
        • Certificates
        • TLS/SSL Server Authentication
          • Designating an OpenSSL Library
        • TLS/SSL Client Authentication
        • Summary of Data Encryption Related Options
          • Connection String Examples for Configuring Data Encryption
          • odbc.ini File Examples for Configuring Data Encryption
        • Generating TLS/SSL certificates using OpenSSL 3.5-compliant algorithms
    • 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
      • Summary of Pooling-Related Options
    • Using 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
      • Summary of Related options for DataDirect Bulk Load
    • Using Bulk Load for Batch Inserts
      • Determining the Bulk Load Protocol
      • Summary of Related Options for Bulk Load or Batch Inserts
  • Configuring the Product on UNIX/Linux
    • Environment Variables
      • Library Search Path
      • ODBCINI
      • ODBCINST
      • DD_INSTALLDIR
    • The Test Loading Tool
    • Data Source Configuration Through the System Information (odbc.ini) File
      • Sample Default odbc.ini File
      • Translators
    • The demoodbc Application
    • DSN-less Connections
      • Sample odbcinst.ini File
    • File Data Sources
    • Password Encryption Tool (UNIX/Linux only)
    • UTF-16 Applications on UNIX and Linux
  • Drivers for 32-Bit and 64-Bit Platforms
    • The Progress OpenEdge Wire Protocol Driver
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX odbc.ini File
        • Data Source Configuration through a GUI (OpenEdge)
        • Using a Connection String
        • Using a Logon Dialog Box (OpenEdge)
      • Connection Option Descriptions for OpenEdge Wire Protocol
        • Alternate Servers
        • Connection Retry Count
        • Connection Retry Delay
        • Crypto Protocol Version
        • CryptoLibName
        • Data Source Name
        • Database Name
        • Default Isolation Level
        • Description
        • Enable FIPS
        • Enable Timestamp with Timezone
        • Encryption Method
        • Failover Granularity
        • Failover Mode
        • Failover Preconnect
        • Fetch Array Size
        • Host Name
        • HostName In Certificate
        • IANAAppCodePage
        • Load Balancing
        • Login Timeout
        • OpenSSLConfigFile
        • OpenSSLProviderPath
        • Password
        • Port Number
        • Query Timeout
        • SSLLibName
        • TCP Keep Alive
        • Truststore
        • Truststore Password
        • Use Wide Character Types
        • User ID
        • Validate Server Certificate
      • Performance Considerations
      • Data Types
      • Unicode Support
      • Advanced Features
        • Failover
        • Security
      • Isolation and Lock Levels Supported
      • SQL Grammar Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
    • The Sybase Wire Protocol Driver
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX/Linux odbc.ini File
        • Data Source Configuration through a GUI (Sybase)
        • Using a Connection String
        • Using a Logon Dialog Box (Sybase)
      • Connection Option Descriptions for Sybase Wire Protocol
        • Alternate Servers
        • Application Name
        • Application Using Threads
        • Authentication Method
        • Batch Size
        • Bulk Binary Threshold
        • Bulk Character Threshold
        • Charset
        • Connection Cache Size
        • Connection Pooling
        • Connection Reset
        • Connection Retry Count
        • Connection Retry Delay
        • Crypto Protocol Version
        • CryptoLibName
        • Cursor Positioning for Raiserror
        • Data Source Name
        • Database List
        • Database Name
        • Description
        • Default Buffer Size for Long/LOB Columns (in Kb)
        • Distributed Transaction Model
        • Enable Bulk Load
        • Enable Describe Parameter
        • Enable FIPS
        • Enable Quoted Identifiers
        • Encryption Method
        • Failover Granularity
        • Failover Mode
        • Failover Preconnect
        • Fetch Array Size
        • Fetch TWFS as Time
        • Field Delimiter
        • GSS Client Library
        • HA Failover Server Connection Information/Network Address
        • Host Name In Certificate
        • IANAAppCodePage
        • Initialization String
        • Interfaces File
        • Language
        • Load Balance Timeout
        • Load Balancing
        • Login Timeout
        • Max Pool Size
        • Min Pool Size
        • Network Address
        • OpenSSLConfigFile
        • OpenSSLProviderPath
        • Packet Size
        • Password
        • Prepare Method
        • PRNGSeedFile
        • PRNGSeedSource
        • Query Timeout
        • Record Delimiter
        • Report Codepage Conversion Errors
        • Select Method
        • Server Name
        • Service Principal Name
        • SSLLibName
        • TCP Keep Alive
        • Tightly Coupled Distributed Transactions
        • Truncate Time Type Fractions
        • Truststore
        • Truststore Password
        • User Name
        • Validate Server Certificate
        • Workstation ID
        • XA Open String Parameters
      • Performance Considerations
      • Data Types
      • Unicode Support
      • Advanced Features
        • Failover
        • Security
          • Authentication
        • Connection Pooling
        • DataDirect Bulk Load
          • Bulk Copy Operations and Transactions
          • Limitations
      • Performance Considerations
      • Unexpected Characters
      • MTS Support
      • NULL Values
      • Persisting a Result Set as an XML Data File
      • Isolation and Lock Levels Supported
      • SQL Grammar Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
      • Using Arrays of Parameters
    • The Text Driver
      • Driver Requirements
      • Formats for Text Files
      • Configuring Data Sources
        • Data Source Configuration in the UNIX/Linux odbc.ini File
        • Data Source Configuration through a GUI (Text)
      • Using a Connection String
      • Connection Option Descriptions
        • Action for Undefined Tables
        • Allow Update And Delete
        • Application Using Threads
        • Cache Size
        • Century Boundary
        • Column Names in First Line
        • Data File Extension
        • Data Source Name
        • Database Directory
        • Decimal Symbol
        • Default Table Type
        • Delimiter Character
        • Description
        • Extension List
        • File Open Cache
        • IANAAppCodePage
        • Include Files with Matching Extensions
        • International Sort
        • Rows to Scan
        • Use Long Qualifiers
      • Defining Table Structure on Windows
      • Defining Table Structure on UNIX and Linux
      • Example of QETXT.INI
      • Date Masks
      • Data Types
      • Select Statement
      • Alter Table Statement
      • SQL Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
  • Drivers Only Available for 32-Bit Platforms
    • The Btrieve (Pervasive.SQL) Driver
      • Driver Requirements
      • Managing Databases
      • Transactions
      • Configuring and Connecting to Data Sources (Btrieve)
        • Data Source Configuration through a GUI (Btrieve)
          • Using a Connection String
        • Using a Connection String
      • Connection Option Descriptions
        • Action for Undefined Tables
        • Application Using Threads
        • Array Size
        • Data File Extension
        • Data Source Name
        • Database Directory
        • Default Logon ID
        • Description
        • File Open Cache
        • International Sort
        • Password
        • Use Long Qualifiers
      • Defining Table Structure
      • Data Types
      • Indexes
      • Column Names
      • Select Statement
        • Rowid Pseudo-Column
      • Alter Table Statement
      • Create and Drop Index Statements
        • Create Index
        • Drop Index
      • Isolation and Lock Levels Supported
      • SQL Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
    • The dBASE Driver
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX/Linux odbc.ini File
        • Data Source Configuration through a GUI (dBase)
        • Data Source Configuration through a GUI (FoxPro)
        • Using a Connection String
      • Connection Option Descriptions
        • Application Using Threads
        • Cache Size
        • Create Type [dBASE]
        • Create Type [FoxPro]
        • Data File Extension
        • Data Source Name
        • Database Directory
        • Database Name
        • Description
        • Extension Case
        • File Open Cache
        • IANAAppCodePage
        • International Sort
        • Lock Compatibility
        • Locking
        • Use Long Names
        • Use Long Qualifiers
      • Defining Index Attributes on Windows
      • Defining Index Attributes on UNIX and Linux
      • Data Types
      • Column Names
      • Select Statement
        • Rowid Pseudo-Column
      • Alter Table Statement
      • Create and Drop Index Statements
        • Create Index
        • Drop Index
      • Pack Statement
      • SQL Statements for FoxPro 3.0 Database Containers
      • Locking
        • Levels of Database Locking
        • Limit on Number of Locks
        • How Transactions Affect Record Locks
      • Isolation and Lock Levels Supported
      • SQL Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
    • The XML Driver
      • Driver Requirements
      • Supported Tabular Formats for XML Documents
      • Hierarchical-Formatted XML Document Support
        • Column Data Types
      • Defining Locations
      • Specifying Table Names in SQL Statements
      • Configuring and Connecting to Data Sources (XML)
        • Data Source Configuration through a GUI (XML)
        • Using a Logon Dialog Box (XML)
        • Using a Connection String
      • Connection Option Descriptions
        • Data Source Name
        • Description
        • Driver Options
        • International Sort Order
        • Location Names
        • Logging
        • Read Only
        • Report Codepage Conversion Errors
        • Schema Mode
        • Show Manufactured Schemas
        • Show Virtual Schemas
          • Configure Location Dialog Box Descriptions
        • Delete Linked Schema
        • Flush Every Change
        • Location
        • Location Name
        • Location Type
        • Max Rows to Scan
        • Password
        • Require User ID/Password
        • Resolve External References
        • Row Hint
        • Table Creation
        • Table Hint
        • User ID
        • Validate Schema
      • Using Hints for Tabular-Formatted XML Documents
        • Column Mode Identifier
      • Data Types
      • Unicode Support
      • Persisting a Result Set as an XML Data File
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
      • SQL Support
        • SQL Statements
        • Extensions to SQL Standards
        • Grammar Token Definitions
          • Regular Identifiers
          • Delimited Identifiers
          • Integer Numbers
          • Real Numbers
          • Character String Literals
          • GUID Literals
          • Hex Literals
          • Time and Date Literals
          • SQL Operators and Symbols
          • Keywords for the XML Driver
          • SQL Comments
  • The Connect XE Drivers
    • The Greenplum Wire Protocol Driver
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX/Linux odbc.ini File
        • Data Source Configuration through a GUI (Greenplum)
        • Using a Connection String
        • Using a Logon Dialog Box (Greenplum)
      • Accessing Greenplum data with Power BI
      • Greenplum Connection Option Descriptions
        • Alternate Servers
        • Application Using Threads
        • Authentication Method
        • Batch Mechanism
        • Connection Pooling
        • Connection Reset
        • Connection Retry Count
        • Connection Retry Delay
        • Crypto Protocol Version
        • CryptoLibName
        • Data Source Name
        • Database Name
        • Description
        • Enable FIPS
        • Enable Keyset Cursors
        • Enable SQLDescribeParam
        • Encryption Method
        • Extended Column MetaData
        • Failover Granularity
        • Failover Mode
        • Failover Preconnect
        • Fetch RefCursors
        • Fetch TSWTZ as Timestamp
        • Fetch TWFS as Time
        • GSS Client Library
        • Host Name
        • Host Name In Certificate
        • IANAAppCodePage
        • Initialization String
        • Keyset Cursor Options
        • Key Password
        • Keystore
        • Keystore Password
        • Load Balance Timeout
        • Load Balancing
        • Login Timeout
        • Max Char Size
        • Max Long Varchar Size
        • Max Pool Size
        • Min Pool Size
        • Max Varchar Size
        • OpenSSLConfigFile
        • OpenSSLProviderPath
        • Password
        • Port Number
        • Query Timeout
        • Report Codepage Conversion Errors
        • Service Principal Name
        • SSLLibName
        • TCP Keep Alive
        • Transaction Error Behavior
        • Truststore
        • Truststore Password
        • User Name
        • Validate Server Certificate
        • Unbounded Numeric Precision
        • Unbounded Numeric Scale
        • User Name
        • XML Describe Type
      • Performance Considerations
      • Data Types
        • Using the XML Data Type
      • Unicode Support
      • Advanced Features
        • Failover
        • Connection Pooling
        • Security
      • User-defined Functions' Results
      • Persisting a Result Set as an XML Data File
      • Isolation and Lock Levels Supported
      • SQL Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
      • Using Arrays of Parameters
    • The Impala Wire Protocol Driver
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX odbc.ini File
        • Data Source Configuration through a GUI (Impala)
        • Using a Connection String
        • Using a Logon Dialog Box (Impala)
      • Connection Option Descriptions
        • Array Size
        • Authentication Method
        • Batch Mechanism
        • Crypto Protocol Version
        • CryptoLibName
        • Data Source Name
        • Database
        • Default Buffer Size for Long/LOB Columns (in Kb)
        • Default Order By Limit
        • Description
        • Enable FIPS
        • Enable SQLDescribeParam
        • Encryption Method
        • GSS Client Library
        • Host Name
        • Host Name In Certificate
        • Key Password
        • Key Store
        • Keystore Password
        • Login Timeout
        • Max Varchar Size
        • OpenSSLConfigFile
        • OpenSSLProviderPath
        • Password
        • Port Number
        • Proxy User
        • Remove Column Qualifiers
        • Service Principal Name
        • SSLLibName
        • String Describe Type
        • TCP Keep Alive
        • Transaction Mode
        • Trust Store Password
        • Truststore
        • Use Current Schema for Catalog Functions
        • User Name
        • Validate Server Certificate
      • Performance Considerations
      • Data Types
      • Advanced Features
        • Security
          • Apache Sentry
      • Materialized Views
      • Stored Procedures
      • Unicode Support
      • Isolation and Lock Levels Supported
      • SQL Support
      • ODBC Conformance Level
      • Using Arrays of Parameters
      • Limitations on Cloudera Impala Functionality
    • The Driver for the Teradata Database
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX/Linux odbc.ini File
        • Using a Connection String
        • Data Source Configuration through a GUI (Teradata)
        • Using a Logon Dialog Box (Teradata)
      • Connection Option Descriptions
        • Account String
        • Authentication Password
        • Authentication UserId
        • DBCName List
        • DBCName or Alias
        • Default Database
        • Default Role
        • Description
        • Enable Data Encryption
        • Enable Extended Statement Information
        • Enable LOBs
        • Enable Reconnect
        • IANAAppCodePage
        • Integrated Security
        • Login Timeout
        • Map Call Escape To Exec
        • Maximum Response Buffer Size
        • Name
        • Password
        • Port Number
        • ProcedureWithPrintStmt
        • ProcedureWithSPLSource
        • Profile
        • Realm
        • Report Codepage Conversion Errors
        • Security Mechanism
        • Security Parameter
        • Session Character Set
        • Show Selectable Tables
        • TDUserName
        • UserID
      • Data Types
      • Unicode Support
      • Persisting a Result Set as an XML Data File
      • Isolation and Lock Levels Supported
      • SQL Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
  • Supported SQL Statements and Extensions
    • SQL Statements for Flat-File Drivers
      • Select Statement
        • Select Clause
          • Aggregate Functions
        • From Clause
        • Where Clause
        • Group By Clause
        • Having Clause
        • Union Operator
        • Order By Clause
        • For Update Clause
        • SQL Expressions
          • Constants
          • Exponential Notation
          • Numeric Operators
          • Character Operators
          • Date Operators
          • Relational Operators
          • Logical Operators
          • Operator Precedence
          • Functions
      • Create and Drop Table Statements
        • Create Table
        • Drop Table
      • Insert Statement
      • Update Statement
      • Delete Statement
      • Reserved Keywords
    • SQL Functionality for the Impala Wire Protocol Driver
      • Data Definition Language (DDL)
      • Selecting Data With the Driver
        • Select List
          • 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
        • Insert and Update Restrictions
        • Stored Procedures
        • Views
        • Other Restrictions
  • Copyright
Table of Contents

SQL Support

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: October 7, 2020
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Cloudera Impala 7.1
    • dBase 7.1
    • Flat files/Text 7.1
    • MySQL 7.1
    • Pervasive (Btrieve) 7.1
    • XML 7.1
    • Documentation

The driver supports the core SQL grammar and the Cloudera Impala query language.

Refer to the Impala SQL Language Reference for information about using Impala SQL.

Also, see SQL Functionality for the Impala Wire Protocol driver.

TitleResults for “How to create a CRG?”Also Available inAlert