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 MongoDB User's Guide Release 8.0.1

Supported SQL statements

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
    • ODBC compliance
    • Version string information
      • getFileVersionString function
    • Support for multiple environments
      • Support for Windows environments
        • 32-bit driver
        • 64-bit driver
        • Setup of the driver
        • Driver file names for Windows
      • Support for UNIX and Linux environments
        • 32-bit driver requirements
        • 64-bit driver requirements
        • AIX
        • HP-UX 11 aCC
        • Linux
        • Oracle Solaris
        • Setup of the environment and the drivers
        • Driver names for UNIX/Linux
    • Data types
      • Default mapping of columns with inconsistent native data types
      • Retrieving data type information
    • Mapping objects to tables
      • Normalizing native data
      • Mapping nested complex types
      • Flattening native data
    • 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
    • Accessing Data in Tableau (Windows only)
    • Accessing data in Microsoft Excel (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
        • The example application
        • 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
        • Security tab
      • Using a connection string
      • Using a logon dialog box
    • Creating and customizing schemas using the DataDirect Schema Tool
      • Starting the Schema Tool
        • Starting the Schema Tool on UNIX/Linux
        • Starting the Schema Tool on Windows
      • Creating a schema with the Table Wizard
        • Generating a normalized view
        • Generating a flattened view
        • Starting with custom view
      • Customizing your schema
        • Viewing information and statistics
          • About column information and statistics
        • Mapping native objects in a schema
          • Mapping native objects
          • Mapping newly detected objects
        • Extracting a new table
        • Adding columns
        • Removing objects from a schema
        • Removing columns
        • Defining columns
        • Designating a primary key
        • Naming conflicts
      • Restarting the wizard
    • Performance considerations
    • Configuring the SQL engine server
      • Configuring server mode
      • Starting the SQL engine server
      • Stopping the SQL engine server
      • Configuring Java logging for the SQL engine server
    • Using security
      • Data encryption across the network
      • TLS/SSL encryption
        • Certificates
        • TLS/SSL server authentication
        • TLS/SSL client authentication
      • Using security with the Schema Tool
        • Configuring security for the Schema Tool on Windows
        • Configuring security for the Schema Tool on UNIX/Linux
      • Summary of security-related options
    • Using identifiers
    • Using IP addresses
    • SQL support
    • Parameter metadata support
      • Insert and Update statements
      • Select statements
    • Binding parameter markers
    • Isolation and lock levels supported
    • MongoDB sharding support
    • Number of connections and statements supported
    • Unicode support
  • Connection option descriptions
    • Application Using Threads
    • Config options
      • columnDiscoverySampleSize (config option)
      • DefaultVarcharSize (config option)
      • KeywordConflictSuffix (config option)
      • LeadingUnderscoreReplacement (config option)
      • MaxVarcharSize (config option)
      • MinVarcharSize (config option)
      • SchemaFilter (config option)
      • UppercaseIdentifiers (config option)
    • Create Database
    • Data Source Name
    • Database
    • Description
    • Encryption Method
    • Fetch Size
    • Host Name
    • Host Name In Certificate
    • IANAAppCodePage
    • Initialization String
    • JVM Arguments
    • JVM Classpath
    • Key Password
    • Key Store
    • Key Store Password
    • Log Config File
    • Login Timeout
    • Min Long Varchar Size
    • Password
    • Port Number
    • Read Only
    • Read Preference
    • Report Codepage Conversion Errors
    • Result Memory Size
    • Schema Definition
    • Server Port Number
    • SQL Engine Mode
    • Transaction Mode
    • Trust Store
    • Trust Store Password
    • User Name
    • Validate Server Certificate
    • Varchar Threshold
  • Supported SQL statements
    • Delete
    • 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

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: October 28, 2020
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • MongoDB 8.0
    • Documentation

The MongoDB driver supports the SQL statements, the SQL extensions, and the custom function escape CAST_TO_NATIVE, as described in the following topics.

Related Links
  • Delete
  • 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