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 JDBC for Snowflake User's Guide Release 6.0.1

Operators

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 Snowflake Driver
    • What's new in this release?
    • Requirements
    • Installing and setting up the driver
    • Driver and DataSource classes
    • Connection URL examples
      • User ID/password authentication
      • OAuth 2.0 access token flow
      • OAuth 2.0 authorization code grant
      • OAuth 2.0 client credentials grant
      • OAuth 2.0 refresh token grant
      • Single sign-on authentication
      • Key-pair authentication
      • Proxy server
    • Data types
      • getTypeInfo()
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Tutorials
    • DbVisualizer
      • Adding a driver
      • Connecting and executing SQL statements
    • Interactive SQL
  • 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
    • Authentication
      • User ID/password authentication
      • OAuth 2.0 authentication
        • Creating an OAuth security integration and obtaining client information
          • Creating a Snowflake OAuth security integration
          • Creating an External OAuth security integration
        • Obtaining access and refresh tokens using the Configuration Manager
        • Configuring the driver to use OAuth 2.0
          • Access token flow
          • Authorization code grant
          • Client credentials grant
          • Refresh token grant
      • Single sign-on authentication
      • Key-pair authentication
    • Data Encryption
      • FIPS (Federal Information Processing Standard)
    • Performance considerations
  • Additional features and functionality
    • Using COPY command
  • Connection property descriptions
    • AccessToken
    • AccountName
    • ArrowFallbackToJson
    • AuthenticationMethod
    • AuthURI
    • ClientID
    • ClientSecret
    • ClientSessionKeepAlive
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • DatabaseName
    • DisableSocksProxy
    • FetchSize
    • ImportStatementPool
    • InsensitiveResultSetBufferSize
    • IntegerFieldMapping
    • KeywordConflictSuffix
    • LogConfigFile
    • LoginTimeout
    • MaxPooledStatements
    • OAuthCode
    • PartnerApplicationName
    • Password
    • PrivateKeyContent
    • PrivateKeyFile
    • PrivateKeyPassphrase
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • QueryTimeout
    • ReadAhead
    • ReadOnly
    • RedirectURI
    • RefreshToken
    • RegisterStatementPoolMonitorMBean
    • RoleName
    • Schema
    • Scope
    • SpyAttributes
    • TokenURI
    • UseSessionDatabaseForMetadata
    • User
    • Warehouse
  • Supported SQL statements and extensions
    • Alter Session (EXT)
    • Delete
    • Explain Plan
    • Insert
      • Specifying an external ID column
    • 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
    • Update
    • 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
Table of Contents

Operators

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: November 2, 2020
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Snowflake 6.0
    • TeamCity 6.0
    • Documentation

This section describes the operators that can be used in SQL expressions.

Note: Numeric operators are restricted to numeric types. Numeric operators do not support non-numeric types.
Contents
  • Unary operator
  • Binary operator
  • Arithmetic operators
  • Concatenation operator
  • Comparison operators
  • Logical operators
  • Operator precedence
TitleResults for “How to create a CRG?”Also Available inAlert