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 JDBC™ for MongoDB™ User's Guide Release 6.1.0

SQL escape sequences

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 JDBC for MongoDB Driver
    • What's new in this release?
    • Requirements
    • Migrating schema maps and native files to 6.1
    • Installing and setting up the driver
    • Driver and DataSource classes
    • Connection URL examples
      • No authentication
      • User ID and password
      • Kerberos authentication
      • LDAP authentication
      • TLS/SSL encryption
      • Replica set failover
      • MongoDB Atlas
      • Microsoft Azure Cosmos DB for MongoDB
      • Proxy server
    • Data types
      • Default mapping of columns with inconsistent native data types
      • getTypeInfo()
    • Mapping objects to tables
      • Normalized view
        • Nested complex types (normalized view)
      • Flattened view
      • Mixed view
        • Nested complex types (mixed view)
    • SQL escape sequences
      • Supported scalar functions
      • CAST_TO_NATIVE function escape
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Tutorials
    • Interactive SQL
    • Tableau
    • DbVisualizer
      • Adding a driver
      • Connecting and executing SQL statements
  • Configuring and connecting
    • Setting the classpath
    • Connecting using the JDBC Driver Manager
      • Passing the connection URL
      • Generating connection URLs with the Configuration Manager
      • Testing connections and queries
    • Connecting using data sources
      • How data sources are implemented
      • Creating data sources
        • Example data source
      • Calling a data source in an application
      • Testing a data source connection
    • Refreshing the relational map
    • Authentication
      • User ID and password authentication
      • LDAP authentication
      • Kerberos authentication
        • Kerberos authentication requirements
        • The JAAS login configuration file
    • Data Encryption
      • Configuring TLS/SSL Encryption
      • Configuring TLS/SSL Server Authentication
      • Configuring TLS/SSL Client Authentication
      • FIPS (Federal Information Processing Standard)
    • Proxy server
    • MongoDB Atlas clusters
    • Replica set failover for write operations
    • Performance considerations
  • Additional features and functionality
    • MongoDB sharding
    • Identifiers
    • MongoDB views
    • Local views
    • MinKey and MaxKey values
  • Connection property descriptions
    • ArrayNormalizationThreshold
    • AuthenticationDatabase
    • AuthenticationMethod
    • ColumnDiscoverySampleSize
    • CreateMap
    • CryptoProtocolVersion
    • DatabaseName
    • EnableDNSLookup
    • EncryptionMethod
    • FetchSize
    • FlattenArrayBase
    • HostNameInCertificate
    • ImportStatementPool
    • InitializationString
    • JSONColumns
    • KeyPassword
    • Keystore
    • KeystorePassword
    • KeywordConflictSuffix
    • LeadingUnderscoreReplacement
    • LegacyVirtualKeys
    • LogConfigFile
    • LoginConfigName
    • LoginTimeout
    • MaxPooledStatements
    • MinVarcharSize
    • NetworkMessageCompressors
    • Password
    • PortNumber
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • QualifyNormalizedNames
    • ReadOnly
    • ReadPreference
    • RefreshSchema
    • RegisterStatementPoolMonitorMBean
    • ReplicaSetName
    • ResultMemorySize
    • SchemaFilter
    • SchemaFormat
    • SchemaMap
    • ServerName
    • ServicePrincipalName
    • SpecialCharBehavior
    • SpyAttributes
    • StringTruncationMethodForWrites
    • TimestampFormat
    • TransactionMode
    • Truststore
    • TruststorePassword
    • UppercaseIdentifiers
    • User
    • ValidateServerCertificate
    • VarcharThreshold
  • 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
Table of Contents

SQL escape sequences

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: March 27, 2020
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • MongoDB 6.1
    • Documentation

The driver supports the following SQL escape sequences.

  • Date, Time, and Timestamp Escape Sequences
  • Scalar Functions
  • Outer Join Escape Sequences
  • LIKE Escape Character Sequence for Wildcards

Refer to SQL Escape Sequences for JDBC in the Progress DataDirect for JDBC Drivers Reference for information about SQL escape sequences supported by the driver.

Contents
  • Supported scalar functions
  • CAST_TO_NATIVE function escape
TitleResults for “How to create a CRG?”Also Available inAlert