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 ODBC for Apache Cassandra User's Guide Release 8.0.0

Supported SQL functionality

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 Apache Cassandra Driver
    • What's new in this release?
    • Driver requirements
    • ODBC compliance
    • Version string information
      • getFileVersionString function
    • Data types
      • Retrieving data type information
    • Complex type normalization
      • Collection types
      • Tuple and user-defined types
      • Nested complex types
    • SQL support
    • Additional information
    • Troubleshooting
    • Contacting Technical Support
  • Getting started
    • Configuring and connecting on Windows
      • Setting the library path environment variable (Windows)
      • Configuring a data source
      • Testing the connection
    • Configuring and connecting on UNIX and Linux
      • Environment configuration
      • Test loading the driver
      • Setting the library path environment variable (UNIX and Linux)
      • Configuring a data source in the system information File
      • Testing the connection
  • Tutorials
    • The Example application
    • Accessing data in Tableau (Windows only)
    • Accessing data in Microsoft Excel from the Data Connection Wizard (Windows only)
    • Accessing data in Microsoft Excel from the Query Wizard (Windows only)
  • Using the driver
    • Configuring and connecting to data sources
      • Configuring the product on UNIX/Linux
        • Environment variables
          • Library search path
          • ODBCINI
          • ODBCINST
          • DD_INSTALLDIR
        • The test loading tool
        • Data source configuration on UNIX/Linux
          • Configuration through the system information (odbc.ini) file
            • Sample default odbc.ini file
        • DSN-less connections
          • Sample odbcinst.ini file
        • File data sources
        • UTF-16 applications on UNIX and Linux
      • Data source configuration through a GUI
        • SQL Engine tab
        • Advanced tab
        • Schema Map tab
        • Security tab
      • Using a connection string
      • Password Encryption Tool (UNIX/Linux only)
      • Using a logon dialog box
    • Performance considerations
    • Using the SQL engine server
      • Configuring the SQL engine server on Windows
        • Configuring server mode on Windows
        • Starting the SQL engine server on Windows
        • Stopping the SQL engine server on Windows
      • Configuring the SQL engine server on UNIX/Linux
        • Configuring and starting the SQL engine server on UNIX/Linux
        • Stopping the SQL engine server on UNIX/Linux
      • Configuring Java logging for the SQL engine server
    • Using failover in a cluster
    • Using identifiers
    • Isolation and lock levels supported
    • Number of connections and statements supported
    • Unicode support
    • Binding parameter markers
    • Parameter metadata support
      • Insert and Update statements
      • Select statements
    • Operation timeouts
    • Out-of-memory issues
    • Packet logging
  • Connection option descriptions
    • Application Using Threads
    • Ascii Size
    • Authentication Method
    • Cluster Nodes
    • Config Options
      • SchemaFormat (config option)
    • Create Map
    • Data Source Name
    • Decimal Precision
    • Decimal Scale
    • Description
    • Fetch Size
    • Host Name
    • IANAAppCodePage
    • Initialization String
    • JVM Arguments
    • JVM Classpath
    • Keyspace Name
    • Log Config File
    • Login Timeout
    • Native Fetch Size
    • Password
    • Port Number
    • Read Consistency
    • Read Only
    • Report Codepage Conversion Errors
    • Result Memory Size
    • Schema Map
    • Server Port Number
    • SQL Engine Mode
    • Transaction Mode
    • User Name
    • Varchar Size
    • Varint Precision
    • Write Consistency
  • Supported SQL functionality
    • Data definition language (DDL)
      • Native and Refresh escape clauses
    • Delete
    • Insert
    • Refresh Map (EXT)
    • Select
      • Select clause
        • Aggregate functions
        • From clause
          • Outer join escape sequences
          • 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 functionality

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: July 25, 2025
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Apache Cassandra 8.0
    • Documentation

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

Contents
  • Data definition language (DDL)
  • Delete
  • Insert
  • Refresh Map (EXT)
  • Select
  • Update
  • SQL expressions
  • Subqueries
TitleResults for “How to create a CRG?”Also Available inAlert