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 MongoDB User's Guide Release 8.1.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 MongoDB Driver
    • What's new in this release?
    • Driver requirements
    • Migrating schema maps and native files to 8.1
    • Installing and setting up the driver (Windows)
    • Installing and setting up the driver (UNIX/Linux)
    • Connection string examples
      • User ID and password authentication
      • No authentication
      • Kerberos authentication
      • LDAP authentication
      • TLS/SSL encryption
      • Replica set failover
      • MongoDB Atlas
      • Microsoft Azure Cosmos DB for MongoDB
    • Data types
      • Default mapping of columns with inconsistent native data types
    • Mapping objects to tables
      • Normalized view
        • Nested complex types (normalized view)
      • Flattened view
      • Mixed view
        • Nested complex types (mixed view)
    • 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
      • UNIX/Linux environment variables
        • Library search path
        • ODBCINI
        • ODBCINST
        • DD_INSTALLDIR
        • The Test Loading Tool
      • UTF-16 applications on UNIX and Linux
    • Configuring data sources with the Configuration Manager
    • Generating connection strings with the Configuration Manager
    • Using a connection string
    • Additional configuration methods for UNIX and 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
      • User ID and password authentication
      • LDAP authentication
      • Kerberos authentication
    • TLS/SSL encryption
      • TLS/SSL server authentication
      • TLS/SSL client authentication
      • Supported keystores and truststores
    • Proxy server
    • MongoDB Atlas clusters
    • Replica set failover for write operations
    • Performance considerations
  • Using the SQL engine server
    • Configuring the SQL engine server using the Configuration Manager
      • Stopping the SQL engine server using the Configuration Manager
    • Configuring Broker mode for the SQL engine server on UNIX/Linux
    • Configuring server mode using Java options
      • Stopping the SQL engine server
    • Configuring Java logging for the SQL engine server
  • Additional features and functionality
    • MongoDB sharding support
    • Using identifiers
    • Parameter metadata support
    • Binding parameter markers
    • MongoDB views
    • Local views
    • MinKey and MaxKey values
    • Packet logging
  • Connection option descriptions
    • Application Using Threads
    • Array Normalization Threshold
    • Authentication Method
    • Authentication Database
    • Broker Idle Timeout
    • Broker Ping Interval
    • Broker Port Number
    • Column Discovery Sample Size
    • Create Map
    • Crypto Protocol Version
    • Data Source Name
    • Database Name
    • Description
    • Enable DNS Lookup
    • Encryption Method
    • Extended Options
    • Fetch Size
    • Flatten Array Base
    • Host Name
    • Host Name in Certificate
    • Initialization String
    • JSON Columns
    • JVM Arguments
    • JVM Classpath
    • JVM Path
    • Key Password
    • Keystore
    • Keystore Password
    • Keyword Conflict Suffix
    • Leading Underscore Replacement
    • Legacy Virtual Keys
    • Log Config File
    • Max Connections Per Server
    • Min Varchar Size
    • Network Message Compressors
    • Password
    • Port Number
    • Proxy Host
    • Proxy Password
    • Proxy Port
    • Proxy User
    • Qualify Normalized Names
    • Read Only
    • Read Preference
    • Refresh Schema
    • Replica Set Name
    • Report Codepage Conversion Errors
    • Result Memory Size
    • Schema Filter
    • Schema Format
    • Schema Map
    • Server Idle Timeout
    • Server Launch Timeout
    • Server Port Number
    • Service Principal Name
    • Special Char Behavior
    • SQL Engine Mode
    • SQL Service
    • String Truncation Method for Writes
    • Timestamp Format
    • Transaction Mode
    • Truststore
    • Truststore Password
    • Uppercase Identifiers
    • User
    • Validate Server Certificate
    • Varchar Threshold
  • Supported SQL statements and extensions
    • Create View
    • Delete
    • Drop View
    • Insert
    • Refresh Map (EXT)
    • Reload 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
    • Custom function escapes
      • CAST_TO_NATIVE function escape
  • 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
    • MongoDB 8.0
    • Documentation

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

Contents
  • Create View
  • Delete
  • Drop View
  • Insert
  • Refresh Map (EXT)
  • Reload Map (EXT)
  • Select
  • Update
  • SQL Expressions
  • Subqueries
  • Custom function escapes
TitleResults for “How to create a CRG?”Also Available inAlert