Using This Reference
Code Page Values
IANAAppCodePage Values
IBM to IANA Code Page Values
Teradata Code Page Values
ODBC API and Scalar Functions
API Functions
Scalar Functions
String Functions
Numeric Functions
Date and Time Functions
System Functions
Threading
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
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
DataDirect Bulk Load
DataDirect Bulk Load Functions
Utility Functions
GetBulkDiagRec and GetBulkDiagRecW
Export, Validate, and Load Functions
ExportTableToFile and ExportTableToFileW
ValidateTableFromFile and ValidateTableFromFileW
LoadTableFromFile and LoadTableFromFileW
Using the TableName Parameter with the Salesforce Driver
SetBulkOperation (Salesforce Driver Only)
GetBulkOperation (Salesforce Driver Only)
DataDirect Bulk Load Statement Attributes
SQL_BULK_EXPORT_PARAMS
SQL_BULK_EXPORT
SQL Statements and Extensions for the Salesforce Driver
Alter Cache (EXT)
Relational Caches
Alter Index
Alter Sequence
Alter Session (EXT)
Alter Table
Altering a Remote Table
Add Clause: Columns
Add Clause: Constraints
Drop Clause: Columns
Altering a Local Table
Add Clause: Columns
Add Clause: Constraints
Drop Clause: Columns
Drop Clause: Constraints
Rename Clause
Checkpoint
Create Cache (EXT)
Relational Caches
Referencing Clause
Refresh Interval Clause
Initial Check Clause
Persist Clause
Enabled Clause
Call Limit Clause
Filter Clause
Create Index
Create Sequence
Next Value For Clause
Create Table
Creating a Remote Table
Column Definition for Remote Tables
Constraint Definition for Remote Tables
Foreign Key Clause
Creating a Local Table
Column Definition for Local Tables
Constraint Definition for Local Tables
Create View
Delete
Drop Cache (EXT)
Drop Index
Drop Sequence
Drop Table
Drop View
Explain Plan
Insert
Specifying an External ID Column
Refresh Cache (EXT)
Refresh Schema (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
Set Checkpoint Defrag
Set Logsize
Update
SQL Expressions
Column Names
Literals
Character String Literals
Integer Literals
Numeric Literals
Binary Literals
Date/Time 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
SQL Functionality for the Driver for Apache Hive
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
Restrictions
Insert and Update Restrictions
Stored Procedures
Views
Other Restrictions
SQL Statements for Flat-File Drivers
Select Statement
Select Clause
Aggregate Functions
From Clause
Where Clause
Group By Clause
Having Clause
Union Operator
Order By Clause
For Update Clause
SQL Expressions
Constants
Exponential Notation
Numeric Operators
Character Operators
Date Operators
Relational Operators
Logical Operators
Operator Precedence
Functions
Create and Drop Table Statements
Create Table
Drop Table
Insert Statement
Update Statement
Delete Statement
Reserved Keywords
SQL Functionality for the Impala Wire Protocol Driver
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
Restrictions
Insert and Update Restrictions
Stored Procedures
Views
Other Restrictions
WorkAround Options
Using This Reference
WorkAround Options