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 Amazon Redshift User's Guide Release 6.0.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 JDBC for Amazon Redshift 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
      • Proxy server
    • Data types
      • getTypeInfo()
    • Driver specifications
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Tutorials
    • Tableau
    • DbVisualizer
      • Adding a driver
      • Connecting and executing SQL statements
    • Interactive SQL for JDBC (JDBCISQL)
  • Configuring and connecting
    • 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
    • Authentication
    • Performance considerations
    • Failover support
    • Data Encryption
      • Configuring TLS/SSL Encryption
      • Configuring TLS/SSL Server Authentication
      • Configuring TLS/SSL Client Authentication
      • FIPS (Federal Information Processing Standard)
  • Additional features and functionality
    • Parameter metadata support
    • ResultSet metadata support
    • Client information
    • Large object (LOB) support
    • Batch inserts and updates
    • DataDirect Bulk Load
      • Using a DDBulkLoad object
        • Exporting data to a CSV file
        • Loading Data from a ResultSet object
        • Loading data from a CSV file
        • Specifying the bulk load operation
        • Logging
      • Permissions for bulk load from a CSV file
    • Using CSV files
      • Bulk load configuration file
      • Bulk load configuration file schema
        • Verifying the bulk load configuration file for database connections
      • Character set conversions
      • External overflow files
      • Discard file
  • Connection property descriptions
    • AccountingInfo
    • ApplicationName
    • BatchMechanism
    • BulkLoadBatchSize
    • CallEscapeBehavior
    • CatalogOptions
    • ClientHostName
    • ClientUser
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CryptoProtocolVersion
    • DatabaseName
    • EnableCancelTimeout
    • EncryptionMethod
    • ExtendedColumnMetadata
    • HostNameInCertificate
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • JavaDoubleToString
    • KeyPassword
    • KeyStore
    • KeyStorePassword
    • LoginTimeout
    • MaxNumericPrecision
    • MaxNumericScale
    • MaxPooledStatements
    • MaxVarcharSize
    • Password
    • PortNumber
    • ProgramID
    • ProxyHost
    • ProxyPort
    • ProxyUser
    • ProxyPassword
    • QueryTimeout
    • RegisterStatementPoolMonitorMBean
    • ResultSetMetaDataOptions
    • ServerName
    • SpyAttributes
    • SupportsCatalogs
    • TransactionErrorBehavior
    • TrustStore
    • TrustStorePassword
    • User
    • UseSystemProxyOptions
    • VarcharClobThreshold
    • ValidateServerCertificate
  • 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

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: November 2, 2020
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Amazon Redshift 6.0
    • Documentation

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

Contents
  • Alter Session (EXT)
  • Delete
  • Explain Plan
  • Insert
  • Select
  • Update
  • Subqueries
  • SQL expressions
TitleResults for “How to create a CRG?”Also Available inAlert