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 Aha! 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 Aha! Driver
    • What's new in this release?
    • Driver requirements
    • Installing and setting up the driver (Windows)
    • Installing and setting up the driver (Linux)
    • Connection string examples
      • Basic authentication
      • URL parameter (API key) authentication
      • OAuth 2.0 access token flow
      • OAuth 2.0 authorization code grant
      • Proxy server
    • Data types
    • Driver specifications
    • Additional information
    • Troubleshooting
    • Contacting Technical Support
  • Tutorials
    • The Example application
    • Power BI (Windows only)
    • Tableau (Windows only)
    • Microsoft Excel (Windows only)
  • Configuring and connecting to data sources
    • Environment settings
      • Windows environment variables
      • Linux environment variables
        • Library search path
        • ODBCINI
        • ODBCINST
        • DD_INSTALLDIR
        • The test loading tool
      • UTF-16 applications on Linux
    • Configuring data sources with the Configuration Manager
    • Generating connection strings with the Configuration Manager
    • Using a connection string
    • Additional configuration methods for 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
      • Basic authentication
      • URL parameter (API key) authentication
      • OAuth 2.0 authentication
        • Access token flow
        • Authorization code grant
    • Performance considerations
  • 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
    • Application Using Threads
    • Authorization Code
    • Authentication Method
    • Client ID
    • Client Secret
    • Create Map
    • Data Source Name
    • Debug Folder
    • Default Query Options
    • Description
    • Extended Options
    • Fetch Size
    • Host Name
    • Initialization String
    • JVM Arguments
    • JVM Classpath
    • JVM Path
    • Log Config File
    • Password
    • Proxy Host
    • Proxy Password
    • Proxy Port
    • Proxy User
    • Read Ahead
    • Redirect URI
    • Report Codepage Conversion Errors
    • Schema Map
    • Security Token
    • Server Port Number
    • Server Proxy Host
    • Server Proxy Password
    • Server Proxy Port
    • Server Proxy User
    • Statement Call Limit
    • Statement Call Limit Behavior
    • SQL Engine Mode
    • SQL Service
    • User
    • Web Service Fetch Size
    • Web Service Pool Size
    • Web Service Retry Count
    • Web Service Timeout
  • Supported SQL statements and extensions
    • Alter Session (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
    • Subqueries
      • IN predicate
      • EXISTS predicate
      • UNIQUE predicate
      • Correlated subqueries
    • 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
  • Introduction to the Aha! data model
    • CAPACITYINVESTMENTESTIMATES
    • CAPACITYINVESTMENTS
    • COMMENTS
    • FEATUREATTACHMENTS
    • FEATURECUSTOMFIELDS
    • FEATUREGOALS
    • FEATUREINTEGRATIONFIELDS
    • FEATURELINKS
    • FEATUREREQUIREMENTS
    • FEATURES
    • FEATURESCOREFACTS
    • FEATURETAGS
    • IDEACATEGORIES
    • IDEACUSTOMFIELDS
    • IDEAENDORSEMENTS
    • IDEAS
    • IDEATAGS
    • MASTERFEATURECHILDREN
    • MASTERFEATURECUSTOMFIELDS
    • MASTERFEATUREGOALS
    • MASTERFEATUREINTEGRATIONFIELDS
    • MASTERFEATURELINKS
    • MASTERFEATURES
    • MASTERFEATURETAGS
    • PRODUCTCHILDREN
    • PRODUCTCUSTOMFIELDS
    • PRODUCTS
    • PRODUCTSCREENCUSTOMFIELDOPTIONS
    • PRODUCTSCREENCUSTOMFIELDS
    • PRODUCTSCREENS
    • RELEASECUSTOMFIELDS
    • RELEASEGOALS
    • RELEASEINITIATIVES
    • RELEASEINTEGRATIONFIELDS
    • RELEASES
    • REQUIREMENTATTACHMENTS
    • REQUIREMENTCUSTOMFIELDS
    • REQUIREMENTINTEGRATIONFIELDS
    • REQUIREMENTS
  • 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: July 30, 2025
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Aha! 8.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 Session (EXT)
  • Select
  • Subqueries
  • SQL expressions
TitleResults for “How to create a CRG?”Also Available inAlert