•  Welcome to the Progress DataDirect for ODBC for Apache Spark SQL Wire Protocol Driver: Version 8.0.2
  • What's New in this Release?
  • Driver Requirements
  • ODBC Compliance
  •  Version String Information
    • getFileVersionString Function
  •  Support for Multiple Environments
    •  Environment-Specific Information
      •  Support for Windows Environments
        • 32-Bit Driver
        • 64-Bit Driver
        • Setup of the Driver
        • Driver Names for Windows
      •  Support for UNIX and Linux Environments
        • 32-Bit Driver
        • 64-Bit Drivers
        • AIX
        • HP-UX 11 aCC
        • Linux
        • Oracle Solaris
        • Setup of the Environment and the Drivers
        • Driver Names for UNIX/Linux
  •  Data Types
    • Retrieving Data Type Information
  • Contacting Technical Support
•  Quick Start Connect
  •  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
•  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
      • The Example Application
      •  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
    • Using a Logon Dialog Box
  • Performance Considerations
  •  Using Security
    •  Authentication
      • Kerberos Authentication
    • Data Encryption Across the Network
    •  SSL Encryption
      • Certificates
      • SSL Server Authentication
      • SSL Client Authentication
      • Designating an OpenSSL Library
    • Summary of Security-Related Options
  • Using IP Addresses
  • 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
•  Troubleshooting
  •  Diagnostic Tools
    •  ODBC Trace
      • Creating a Trace Log
      •  Enabling Tracing
        • Windows ODBC Administrator
        • System Information (odbc.ini) File
    • The Test Loading Tool
    • ODBC Test
    • The Example Application
    • Other Tools
  • Error Messages
  •  Troubleshooting
    •  Setup/Connection Issues
      • Troubleshooting the Issue
    •  Interoperability Issues
      • Troubleshooting the Issue
    • Performance Issues
•  Connection Option Descriptions for Apache Spark SQL
  • AllowedOpenSSLVersions
  • Array Size
  • Authentication Method
  • Crypto Protocol Version
  • CryptoLibName
  • Data Source Name
  • Database
  • Default Buffer Size for Long/LOB Columns (in Kb)
  • Description
  • Enable SQLDescribeParam
  • Encryption Method
  • GSS Client Library
  • Host Name
  • Host Name In Certificate
  • IANAAppCodePage
  • Key Password
  • Key Store
  • Key Store Password
  • Login Timeout
  • Max String Size
  • Min Long Varchar Size
  • PortNumber
  • PRNGSeedFile
  • PRNGSeedSource
  • Proxy User
  • Remove Column Qualifiers
  • Service Principal Name
  • SSLLibName
  • String Describe Type
  • TCP Keep Alive
  • Transaction Mode
  • Trust Store
  • Trust Store Password
  • Use Current Schema for Catalog Functions
  • Use Native Catalog Functions
  • User Name
  • Validate Server Certificate
  • Varchar Threshold
•  SQL Functionality for the Driver for Apache Spark SQL
  • 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
•  Reference
  •  What Is ODBC?
    • How Does It Work?
    • Why Do Application Developers Need ODBC?
  •  Code Page Values
    • IANAAppCodePage Values
  •  ODBC API and Scalar Functions
    • API Functions
    •  Scalar Functions
      • String Functions
      • Numeric Functions
      • Date and Time Functions
      • System Functions
  •  Internationalization, Localization, and Unicode
    •  Internationalization and Localization
      • Locale
      • Language
      • Country
      • Variant
    •  Unicode Character Encoding
      • Background
      • Unicode Support in Databases
      • Unicode Support in ODBC
    •  Unicode and Non-Unicode ODBC Drivers
      •  Function Calls
        • Unicode Application with a Non-Unicode Driver
        • Unicode Application with a Unicode Driver
      •  Data
        • Unicode Driver
        • ANSI Driver
      •  Default Unicode Mapping
        • Connection Attribute for Unicode
    •  Driver Manager and Unicode Encoding on UNIX/Linux
      • References
    • Character Encoding in the odbc.ini and odbcinst.ini Files
  •  Designing ODBC Applications for Performance Optimization
    •  Using Catalog Functions
      • Caching Information to Minimize the Use of Catalog Functions
      • Avoiding Search Patterns
      • Using a Dummy Query to Determine Table Characteristics
    •  Retrieving Data
      • Retrieving Long Data
      • Reducing the Size of Data Retrieved
      • Using Bound Columns
      • Using SQLExtendedFetch Instead of SQLFetch
      • Choosing the Right Data Type
    •  Selecting ODBC Functions
      • Using SQLPrepare/SQLExecute and SQLExecDirect
      • Using Arrays of Parameters
      • Using the Cursor Library
    •  Managing Connections and Updates
      • Managing Connections
      • Managing Commits in Transactions
      • Choosing the Right Transaction Model
      • Using Positioned Updates and Deletes
      • Using SQLSpecialColumns
  •  Using Indexes
    • Introduction
    • Improving Row Selection Performance
    • Indexing Multiple Fields
    • Deciding Which Indexes to Create
    • Improving Join Performance
  •  Locking and Isolation Levels
    • Locking
    • Isolation Levels
    • Locking Modes and Levels
  • SSL Encryption Cipher Suites
  • WorkAround Options
  • Threading
•  Glossary
  • application
  • authentication
  • bulk load
  • client load balancing
  • conformance
  • connection pooling
  • connection retry
  • connection string
  • data source
  • driver
  • Driver Manager
  • DSN (Data Source Name)
  • DTC (Distributed Transaction Coordinator)
  • failover
  • index
  • isolation level
  • Kerberos
  • load balancing
  • locking level
  • MTS (Microsoft Transaction Server)
  • NTLM
  • ODBC Administrator
  • OS authentication
  • Performance Tuning Wizard
  • reauthentication
  • SQL Grammar
  • Secure Sockets Layer (SSL)
  • SSL client/server authentication
  • Unicode
  • user ID/password authentication
• Copyright