A
Add clause 1, 2
aggregate functions
flat-file drivers
Salesforce driver
Alter Cache (EXT)
Alter Index
Alter Sequence
Alter Session (EXT)
Alter Table
Apache Hive, driver for
From clause
Group By clause
Having clause
Insert and Update
maximum length of a SQL string
Order By clause
restrictions
SQL statement support
subqueries
views
Apache Hive, the driver for
column name qualification
arithmetic operators 1, 2, 3
arrays of parameter values, passing
Autocommit mode
B
binary
literals
operators
bound columns
Btrieve driver
See flat-file drivers
bulk load
configuration file
data file
functions
bulk errors
bulk export
bulk load 1, 2, 3
bulk load validation
utility
Salesforce driver 1, 2, 3
See Connect Series for ODBC User’s Guide
statement attributes
validating metadata in the bulk load configuration file
C
cache, Salesforce
changing the definition of a cache
creating
enabling
initial check of data
refreshing
relational
setting the life span of data
caching information to improve performance
Call Limit clause
call load, reducing
catalog functions, using
character encoding
character operators 1, 2
character string literals
Checkpoint
cipher suite, encryption
SSL v3 encryption cipher suite
TLS v1 encryption cipher suite
when driver cannot negotiate SSL v3 or TLS v1
client code page
See code pages
code pages
IANAAppCodePage attribute
IBM DB2
Teradata
column
definition
names
comparison operators
concatenation operator 1, 2, 3
conditions
connection handles
connections, optimizing
constants
Apache Hive, driver for
Impala Wire Protocol driver
constraint definition 1, 2
correlated subqueries
Create Cache (EXT)
Create Index
Create Sequence
Create Table statement
flat-file
Salesforce driver
Create View statement
cursor library, performance implications of using
D
data retrieval, optimizing
data type, choosing
date and time functions
date/time literals
DB2, IBM code page values
dBASE driver
See flat-file drivers
Delete statement
flat-file drivers
Salesforce driver
determining optimal set of columns
dirty reads
distributed transactions
double-byte character sets in UNIX and Linux
driver
API and scalar functions
code page values
flat-file
optimizing application performance
threading
using DataDirect bulk load
Drop Cache (EXT)
Drop clause 1, 2
Drop Index
Drop Sequence
Drop Table statement
flat-file drivers
Salesforce driver
Drop View
E
Enabled clause
encryption cipher suites
Except operator
EXISTS predicate
Explain Plan
exporting result sets to a bulk load data file
ExportTableToFile
ExportTableToFileW
external ID column
See Connect Series for ODBC User’s Guide
specifying
F
Filter clause
flat-file drivers
aggregate functions
Create Table statement
Delete statement
Drop Table statement
For Update clause
From clause
Group By clause
Having clause
Insert statement
operator precedence
Order By clause
Select clause
Select statement
SQL expressions
SQL for
Union operator
Update statement
Where clause
Foreign Key clause
From clause
flat-file drivers
Salesforce driver
functions, ODBC
Apache Hive, driver for
DataDirect functions for bulk operations
Impala Wire Protocol driver
Salesforce driver
selecting for performance
G
GetBulkDiagRec
GetBulkDiagRecW
GetBulkOperation
Group By clause
flat-file drivers
Salesforce driver
H
handles
connection
statement
Having clause
flat-file drivers
Salesforce driver
I
IANAAppCodePage, connection option values
Impala Wire Protocol
column name qualification
Impala Wire Protocol driver
Insert and Update
maximum length of a SQL string
restrictions
subqueries
views
Impala Wire Protocol Driver
SQL statement support
improving
database performance
index performance
join performance
ODBC application performance
record selection performance
IN predicate
indexes
deciding which to create
improving performance
indexing multiple fields
Initial Check clause
Insert statement
flat-file drivers
Salesforce driver
integer literals
internationalization
Intersect operator
isolation levels
about
read committed
read uncommitted
repeatable read
serializable
isolation levels and data consistency
compared
dirty reads
non-repeatable reads
phantom reads
J
join in a From clause
L
Limit clause
literals
about
binary
character string
date/time
integer
numeric
LoadTableFromFile
LoadTableFromFileW
local table, Salesforce driver
constraints
creating
defining columns
deleting rows
locale
localization
locking modes and levels
logical operators 1, 2, 3
long data, retrieving
M
managing connections
materialized views 1, 2
MIBenum value
Minus operator
N
Next Value For clause
non-repeatable reads
numeric functions
numeric literals
O
ODBC
API functions
call load, reducing
designing for performance
functions, selecting for performance
scalar functions
OpenSSL cipher suites, mapping
operators
arithmetic 1, 2, 3
comparison
concatenation 1, 2, 3
logical 1, 2, 3
precedence
relational 1, 2
optimization, performance
Order By clause
flat-file drivers
Salesforce driver
P
parameter values, passing arrays of
performance optimization
avoiding catalog functions
avoiding search patterns
commits in transactions
managing connections
overview
reducing the size of retrieved data
retrieving long data
using a dummy query
using bound columns
performance, improving
database using indexes
index
join
record selection
Persist clause
phantom reads
positioned updates and deletes
predicate
EXISTS
IN
UNIQUE
Primary Key clause
R
read committed
read uncommitted
Referencing clause
Refresh Cache (EXT)
Refresh Interval clause
Refresh Schema (EXT)
relational cache
relational operators 1, 2
remote table, Salesforce driver
altering a table
changing the definition of a cache
creating
dropping a table in the SFORCE schema
refreshing data in the cache
Rename clause
repeatable read
reserved keywords
retrieving data, optimizing
returning the bulk operation on the connection
S
Salesforce driver
column mapping with bulk load
creating a local table
Drop Table statement
GetBulkOperation
remote table
SetBulkOperation
SQL statement support
scalar functions, ODBC
scrollable cursors
search patterns, avoiding
Select clause
flat-file drivers
Salesforce driver
Select statement
flat-file drivers
Salesforce driver
serializable isolation level
Set Checkpoint Defrag
Set Logsize
SetBulkOperation
SQL
expressions
driver for Apache Hive
flat-file drivers
Salesforce driver
The Impala Wire Protocol driver
flat-file drivers
reserved keywords
SQL statements
Alter Cache
Alter Index
Alter Sequence
Alter Session
Checkpoint
Create Sequence
Drop Cache
Drop Index 1, 2
Drop Sequence
Drop Table
Drop View
Explain Plan
Insert
Refresh Cache
Set Checkpoint Defrag
Set Logsize
Update
SQLExecDirect, advantages of using
SQLFetch, disadvantage of using
SQLSpecialColumns, determining optimal set of columns
SSL
encryption cipher suites
statement attributes for DataDirect bulk load operations
statement handles, using to manage SQL statements
static cursors
stored procedures 1, 2
string functions
subqueries
Apache Hive, driver for
correlated
Impala Wire Protocol driver
overview
subquery in a From clause
system functions
T
Teradata code page values
The Impala Wire Protocol driver
From clause
Group By clause
Having clause
Order By clause
threading, overview
time functions
TLS v1 encryption cipher suite
transactions, managing commits
U
UCS-2
unary operator
Unicode
character encoding
ODBC drivers
support in databases
support in ODBC
Union operator
flat-file drivers
Salesforce driver
Unique clause
UNIQUE predicate
UNIX and Linux
code pages, IANAAppCodePage attribute
double-byte character sets 1, 2
Update statement
flat-file drivers
Salesforce driver
updates, optimizing
UTF-16
UTF-8
V
ValidateTableFromFile
ValidateTableFromFileW
validating metadata in the bulk load configuration file
views
Apache Hive, driver for
Impala Wire Protocol driver
Salesforce driver
caches not supported
Create View statement
creating
Filter clause
life span of data
W
Where clause
flat-file drivers
Salesforce driver
WorkAround options for ODBC drivers
X
XML driver
See flat-file drivers