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 Apache Spark SQL Wire Protocol User's Guide Release 8.0.2

Selecting data with the driver

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 Apache Spark SQL Wire Protocol Driver
    • What's new in this release?
    • Driver requirements
    • ODBC compliance
    • Version string information
      • getFileVersionString function
    • Data types
      • Retrieving data type information
    • Additional information
    • Troubleshooting
    • Contacting Technical Support
  • Getting started
    • Configuring and connecting on Windows
      • Configuring a data source
      • Testing the connection
    • Configuring and connecting on UNIX and Linux
      • Environment configuration
      • Test loading the driver
      • Configuring a data source in the system information file
      • Testing the connection
  • Tutorials
    • The Example application
    • Microsoft Excel (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
        • DSN-less connections
          • Sample odbcinst.ini file
        • File data sources
        • UTF-16 applications on UNIX and Linux
      • Data source configuration through a GUI
        • Advanced tab
        • Security tab
      • Using a connection string
      • Password Encryption Tool (UNIX/Linux only)
      • Using a logon dialog box
    • Performance considerations
    • Using security
      • Authentication
        • Kerberos authentication
      • Data encryption across the network
      • TLS/SSL encryption
        • Certificates
        • TLS/SSL server authentication
        • TLS/SSL client authentication
        • Generating TLS/SSL certificates using OpenSSL 3.5-compliant algorithms
        • Designating an OpenSSL library
      • Summary of security-related options
    • HTTP mode
    • Azure Databricks Spark clusters
    • SQL support
    • Binding parameter markers
    • Materialized views
    • Stored procedures
    • Isolation and lock levels supported
    • Number of connections and statements supported
    • Unicode support
    • Using arrays of parameters
    • Compatibility with Apache Hive
  • Connection option descriptions
    • Array Size
    • Authentication Method
    • Cookie Name
    • Crypto Protocol Version
    • CryptoLibName
    • Data Source Name
    • Database Name
    • Default Buffer Size for Long/LOB Columns (in Kb)
    • Description
    • Enable Cookie Authentication
    • Enable FIPS
    • Enable SQLDescribeParam
    • Encryption Method
    • GSS Client Library
    • Host Name
    • Host Name In Certificate
    • HTTP Path
    • IANAAppCodePage
    • Key Password
    • Key Store
    • Key Store Password
    • Login Timeout
    • Max String Size
    • Min Long Varchar Size
    • OpenSSLConfigFile
    • OpenSSLProviderPath
    • Password
    • PortNumber
    • PRNGSeedFile
    • PRNGSeedSource
    • Proxy User
    • Remove Column Qualifiers
    • Service Principal Name
    • SSLLibName
    • String Describe Type
    • TCP Keep Alive
    • Transaction Mode
    • Transport Mode
    • Trust Store
    • Trust Store Password
    • Use Current Schema for Catalog Functions
    • Use Native Catalog Functions
    • User Agent
    • User Name
    • Validate Server Certificate
    • Varchar Threshold
  • SQL functionality
    • Data Definition Language (DDL)
    • Selecting data with the driver
      • Select list
        • Column name qualification
    • From clause
    • Group By clause
    • Having clause
    • Order By clause
    • For Update clause
    • Set operators
    • Subqueries
    • SQL expressions
      • Constants
      • Numeric operators
      • Character operator
      • Relational operators
      • Logical operators
      • Functions
  • Copyright
Table of Contents

Selecting data with the driver

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: October 27, 2020
    • DataDirect Connectors
    • ODBC
    • Apache Spark SQL 8.0
    • Documentation

Contents
  • Select list
TitleResults for “How to create a CRG?”Also Available inAlert