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 Jira User's Guide Release 6.0.0

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 Jira Driver
    • What's new in this release?
    • Requirements
    • Installing and setting up the driver
    • Version string information
    • Driver and DataSource classes
    • Connection URL examples
    • Connection properties
    • Introduction to the Jira Data Model
    • Mapping objects to tables
    • Data types
      • getTypeInfo()
    • SQL escape sequences
      • Supported scalar functions
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Using the Driver
    • Required permissions for Java SE with the standard Security Manager enabled
      • Permissions for establishing connections
      • Granting access to Java properties
      • Granting access to temporary files
    • Connecting from an application
      • Setting the classpath
      • Connecting using the JDBC Driver Manager
        • Passing the connection URL
        • Testing the connection
      • 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
    • Connecting through a proxy server
    • IP addresses
    • Performance considerations
    • Data encryption
      • Configuring SSL encryption
      • Configuring SSL server authentication
      • Configuring SSL client authentication
    • Enabling Debug Record Mode
    • Isolation levels
    • Statement Pooling
    • Connection pooling
  • Connection property descriptions
    • ConvertNull
    • CryptoProtocolVersion
    • DebugRecord
    • FetchSize
    • HostNameInCertificate
    • ImportStatementPool
    • InsensitiveResultSetBufferSize
    • JDBCBehavior
    • KeyPassword
    • KeyStore
    • KeyStorePassword
    • LogConfigFile
    • LoginTimeout
    • MaxPooledStatements
    • Password
    • PortNumber
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • ReadAhead
    • RegisterStatementPoolMonitorMBean
    • ServerName
    • SpyAttributes
    • StmtCallLimit
    • StmtCallLimitBehavior
    • TrustStore
    • TrustStorePassword
    • User
    • ValidateServerCertificate
    • WSFetchSize
    • WSPoolSize
    • WSRetryCount
    • WSTimeout
  • Supported SQL statements and extensions
    • Alter Session (EXT)
    • 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
    • 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

Operators

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: May 13, 2025
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Atlassian Jira 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