Index

64-Bit Integer Structures 64-Bit Integer Structures

A

About the Code Examples About the Code Examples
About This Manual About This Manual
Administration Program Administration Program
Affected ODBC Components Affected ODBC Components
Alignment Alignment
Allocating a Connection Handle Allocating a Connection Handle
Allocating a Statement Handle Allocating a Statement Handle
Allocating and Freeing Buffers Allocating and Freeing Buffers
Allocating and Freeing Descriptors Allocating and Freeing Descriptors
Allocating the Environment Handle Allocating the Environment Handle
An Introduction to SQL and ODBC An Introduction to SQL and ODBC
Application/Driver Compatibility Application/Driver Compatibility
Applications Applications
Argument Value Checks Argument Value Checks
Arguments in Catalog Functions Arguments in Catalog Functions
Arrays of Parameter Values Arrays of Parameter Values
Asynchronous Execution Asynchronous Execution
Attribute Conformance Attribute Conformance
Audience Audience
Auto-Commit Mode Auto-Commit Mode
Automatic Population of the IPD Automatic Population of the IPD

B

Backward Compatibility and Standards Compliance Backward Compatibility and Standards Compliance
Backward Compatibility of C Data Types Backward Compatibility of C Data Types
Basic Application Steps Basic Application Steps
Batch Processing Batch Processing
Batches of SQL Statements Batches of SQL Statements
Behavioral Changes Behavioral Changes
Behavioral Changes and ODBC 3.0 Drivers Behavioral Changes and ODBC 3.0 Drivers
Binding Arrays of Parameters Binding Arrays of Parameters
Binding Columns for Use with Block Cursors Binding Columns for Use with Block Cursors
Binding Parameter Markers Binding Parameter Markers
Binding Parameters Binding Parameters
Binding Parameters by Name (Named Parameters) Binding Parameters by Name (Named Parameters)
Binding Result Set Columns Binding Result Set Columns
Block Cursors Block Cursors
Block Cursors, Scrollable Cursors, and Backward Compatibility Block Cursors, Scrollable Cursors, and Backward Compatibility
Block Cursors, Scrollable Cursors, and Backward Compatibility for ODBC 3.0 Applications Block Cursors, Scrollable Cursors, and Backward Compatibility for ODBC 3.0 Applications
Bookmark C Data Type Bookmark C Data Type
Bookmark Types Bookmark Types
Bookmarks Bookmarks
Bound Descriptor Records Bound Descriptor Records
Buffers Buffers

C

C Data Types C Data Types
C Data Types in ODBC C Data Types in ODBC
C Interval Structure C Interval Structure
C to SQL Data Conversion Examples C to SQL Data Conversion Examples
C to SQL: Binary C to SQL: Binary
C to SQL: Bit C to SQL: Bit
C to SQL: Character C to SQL: Character
C to SQL: Date C to SQL: Date
C to SQL: Day-Time Intervals C to SQL: Day-Time Intervals
C to SQL: Numeric C to SQL: Numeric
C to SQL: Time C to SQL: Time
C to SQL: Timestamp C to SQL: Timestamp
C to SQL: Year-Month Intervals C to SQL: Year-Month Intervals
Calling SQLCloseCursor Calling SQLCloseCursor
Calling SQLGetDiagField Calling SQLGetDiagField
Calling SQLSetPos Calling SQLSetPos
Calling SQLSetPos to Insert Data Calling SQLSetPos to Insert Data
Call-Level Interfaces Call-Level Interfaces
Catalog and Schema Usage Catalog and Schema Usage
Catalog Functions Catalog Functions
Catalog Functions in ODBC Catalog Functions in ODBC
Catalog Position Catalog Position
Character Data and C Strings Character Data and C Strings
Checking Feature Support and Variability Checking Feature Support and Variability
Choosing a Data Source or Driver Choosing a Data Source or Driver
Choosing a Level of Interoperability Choosing a Level of Interoperability
Choosing an SQL Grammar Choosing an SQL Grammar
Closing the Cursor Closing the Cursor
Column Binding Offsets Column Binding Offsets
Column Data Column Data
Column Size Column Size
Column Size, Decimal Digits, Transfer Octet Length, and Display Size Column Size, Decimal Digits, Transfer Octet Length, and Display Size
Column-Wise Binding Column-Wise Binding
Commit and Rollback Behavior Commit and Rollback Behavior
Commit Mode Commit Mode
Committing and Rolling Back Transactions Committing and Rolling Back Transactions
Comparing Bookmarks Comparing Bookmarks
Compatibility Matrix Compatibility Matrix
Compiling an Embedded SQL Program Compiling an Embedded SQL Program
Concurrency Control Concurrency Control
Concurrency Types Concurrency Types
ConfigDriver ConfigDriver
ConfigDSN ConfigDSN
ConfigTranslator ConfigTranslator
Configuration Components Configuration Components
Configuring Data Sources Configuring Data Sources
Conformance Levels Conformance Levels
Connecting Directly to Drivers Connecting Directly to Drivers
Connecting to a Data Source or Driver Connecting to a Data Source or Driver
Connecting Using File Data Sources Connecting Using File Data Sources
Connecting with SQLBrowseConnect Connecting with SQLBrowseConnect
Connecting with SQLConnect Connecting with SQLConnect
Connecting with SQLDriverConnect Connecting with SQLDriverConnect
Connection Attributes Connection Attributes
Connection Handles Connection Handles
Connection Pooling Connection Pooling
Connection String Connection String
Connection Transitions Connection Transitions
Considering Database Features to Use Considering Database Features to Use
Consistency Check Consistency Check
Constraints of the Gregorian Calendar Constraints of the Gregorian Calendar
Constructing Interoperable SQL Statements Constructing Interoperable SQL Statements
Constructing Searched Statements Constructing Searched Statements
Constructing SQL Statements Constructing SQL Statements
Converting Data from C to SQL Data Types Converting Data from C to SQL Data Types
Converting Data from SQL to C Data Types Converting Data from SQL to C Data Types
Copying Descriptors Copying Descriptors
Core Interface Conformance Core Interface Conformance
Creating and Terminating Threads Creating and Terminating Threads
CString Class CString Class
Cursor Characteristics and Cursor Type Cursor Characteristics and Cursor Type
Cursor Library Cache Cursor Library Cache
Cursor Library Code Example Cursor Library Code Example
Cursor Library Operations Cursor Library Operations
Cursors Cursors
Custom Applications Custom Applications

D

Data Buffer Address Data Buffer Address
Data Buffer Length Data Buffer Length
Data Buffer Type Data Buffer Type
Data Length, Buffer Length, and Truncation Data Length, Buffer Length, and Truncation
Data Returned by Catalog Functions Data Returned by Catalog Functions
Data Source Example Data Source Example
Data Source Specification Subkeys Data Source Specification Subkeys
Data Sources Data Sources
Data Type Conversions Data Type Conversions
Data Type Identifiers and Descriptors Data Type Identifiers and Descriptors
Data Type Support Data Type Support
Data Types Data Types
Data Types in ODBC Data Types in ODBC
Database Access Architecture Database Access Architecture
Date, Time, and Timestamp Escape Sequences Date, Time, and Timestamp Escape Sequences
Date, Time, and Timestamp Literals Date, Time, and Timestamp Literals
Datetime Data Type Changes Datetime Data Type Changes
Datetime Data Types Datetime Data Types
Datetime Interval Literals Datetime Interval Literals
DBMS-Based Driver Diagnostic Example DBMS-Based Driver Diagnostic Example
DBMS-Based Drivers DBMS-Based Drivers
DDL Statements DDL Statements
Decimal Digits Decimal Digits
Declaring the Application's ODBC Version Declaring the Application's ODBC Version
Default C Data Types Default C Data Types
Default Data Source Default Data Source
Default Driver Subkey Default Driver Subkey
Default Subkey Default Subkey
Deferred Buffers Deferred Buffers
Deferred Fields Deferred Fields
Deleting Rows by Bookmark with SQLBulkOperations Deleting Rows by Bookmark with SQLBulkOperations
Deleting Rows in the Rowset with SQLSetPos Deleting Rows in the Rowset with SQLSetPos
Describing Parameters Describing Parameters
Descriptor Field Conformance Descriptor Field Conformance
Descriptor Fields Descriptor Fields
Descriptor Handles Descriptor Handles
Descriptor Transitions Descriptor Transitions
Descriptors Descriptors
Determining Cursor Capabilities Determining Cursor Capabilities
Determining the Number of Affected Rows Determining the Number of Affected Rows
Determining the Target DBMSs and Drivers Determining the Target DBMSs and Drivers
Diagnostic Handling Examples Diagnostic Handling Examples
Diagnostic Handling Rules Diagnostic Handling Rules
Diagnostic Messages Diagnostic Messages
Diagnostic Records Diagnostic Records
Diagnostics Diagnostics
Direct Execution Direct Execution
Disconnecting from a Data Source or Driver Disconnecting from a Data Source or Driver
Display Size Display Size
Document Conventions Document Conventions
Driver Architecture Driver Architecture
Driver Guidelines for Backward Compatibility Driver Guidelines for Backward Compatibility
Driver Manager Diagnostic Example Driver Manager Diagnostic Example
Driver Manager Error and Warning Checks Driver Manager Error and Warning Checks
Driver Manager's Role in the Connection Process Driver Manager's Role in the Connection Process
Driver Setup DLL Driver Setup DLL
Driver Setup DLLs Driver Setup DLLs
Driver Specification Subkeys Driver Specification Subkeys
Driver Tasks Driver Tasks
Drivers Drivers
Driver-Specific Connection Information Driver-Specific Connection Information
Driver-Specific Data Types, Descriptor Types, Information Types, Diagnostic Types, and Attributes Driver-Specific Data Types, Descriptor Types, Information Types, Diagnostic Types, and Attributes
Duplicated Features Duplicated Features
Dynamic Cursors Dynamic Cursors
Dynamic SQL Dynamic SQL
Dynamic Tracing Dynamic Tracing

E

Effect of Transactions on Cursors and Prepared Statements Effect of Transactions on Cursors and Prepared Statements
Elements Used in SQL Statements Elements Used in SQL Statements
Embedded SQL Embedded SQL
Embedded SQL Example Embedded SQL Example
Enabling Tracing Enabling Tracing
Environment Handles Environment Handles
Environment Transitions Environment Transitions
Environment, Connection, and Statement Attributes Environment, Connection, and Statement Attributes
Errors and Batches Errors and Batches
Escape Sequences Escape Sequences
Escape Sequences in ODBC Escape Sequences in ODBC
Establishing a Connection Establishing a Connection
Executing a Statement Executing a Statement
Executing Batches Executing Batches
Executing Catalog Functions Executing Catalog Functions
Executing Positioned Update and Delete Statements Executing Positioned Update and Delete Statements
Executing Procedures Executing Procedures
Executing Statements Executing Statements
Explicit Data Type Conversion Explicit Data Type Conversion
Explicitly Allocated Descriptors Explicitly Allocated Descriptors

F

Features to Watch For Features to Watch For
Fetching a Row of Data Fetching a Row of Data
Fetching Data Fetching Data
Fetching Rows with SQLBulkOperations Fetching Rows with SQLBulkOperations
File Data Sources File Data Sources
File-Based Driver Diagnostic Example File-Based Driver Diagnostic Example
File-Based Drivers File-Based Drivers
Fixed-Length Bookmarks Fixed-Length Bookmarks
Freeing a Statement Handle Freeing a Statement Handle
Freeing Descriptors Freeing Descriptors
Function Conformance Function Conformance
Function Summary Function Summary

G

Gateways Diagnostic Example Gateways Diagnostic Example
General Error Checks General Error Checks
Generic Applications Generic Applications
Getting and Setting Descriptor Fields Getting and Setting Descriptor Fields
Getting Long Data Getting Long Data
Glossary Glossary
Guidelines for Interval and Numeric Data Types Guidelines for Interval and Numeric Data Types

H

Handles Handles
Hard-Coded SQL Statements Hard-Coded SQL Statements
Header Files Header Files
Header Record Header Record
How is Metadata Used? How is Metadata Used?

I

Identifier Arguments Identifier Arguments
Identifier Case Identifier Case
Implementation Notes Implementation Notes
Implementing SQLGetDiagRec and SQLGetDiagField Implementing SQLGetDiagRec and SQLGetDiagField
Implicitly Allocated Descriptors Implicitly Allocated Descriptors
Initialization of Descriptor Fields Initialization of Descriptor Fields
Inserting Rows with SQLBulkOperations Inserting Rows with SQLBulkOperations
Installation Components Installation Components
Installer DLL Installer DLL
Installer DLL API Reference Installer DLL API Reference
Installer DLL Function Summary Installer DLL Function Summary
Installing ODBC Components Installing ODBC Components
Interface Conformance Levels Interface Conformance Levels
Interoperability Interoperability
Interoperability of SQL Statements Interoperability of SQL Statements
Interval Data Type Length Interval Data Type Length
Interval Data Type Precision Interval Data Type Precision
Interval Data Types Interval Data Types
Interval Escape Sequences Interval Escape Sequences
Interval Literal Syntax Interval Literal Syntax
Interval Literals Interval Literals
Introduction Introduction
Is ODBC the Answer? Is ODBC the Answer?

K

Keyset-Driven Cursors Keyset-Driven Cursors

L

Length of Column Data Length of Column Data
Length of the Product Cycle Length of the Product Cycle
Level 1 Interface Conformance Level 1 Interface Conformance
Level 2 Interface Conformance Level 2 Interface Conformance
Like Escape Sequence Like Escape Sequence
LIKE Predicate Escape Character LIKE Predicate Escape Character
List of Reserved Keywords List of Reserved Keywords
Literal Prefixes and Suffixes Literal Prefixes and Suffixes
Literals in ODBC Literals in ODBC
Loading By Ordinal Loading By Ordinal
Location of Cache Location of Cache
Long Data and SQLSetPos and SQLBulkOperations Long Data and SQLSetPos and SQLBulkOperations

M

Machine Data Sources Machine Data Sources
Manual-Commit Mode Manual-Commit Mode
Mapping Deprecated Functions Mapping Deprecated Functions
Mapping Replacement Functions for Backward Compatibility of Applications Mapping Replacement Functions for Backward Compatibility of Applications
Mapping the Cursor Attributes1 Information Types Mapping the Cursor Attributes1 Information Types
Mixed Cursors Mixed Cursors
Multiple Active Statements and Connections Multiple Active Statements and Connections
Multiple Results Multiple Results
Multithreading Multithreading

N

Network Database Access Network Database Access
Network Example Network Example
New Features New Features
NOT NULL in CREATE TABLE Statements NOT NULL in CREATE TABLE Statements
Number of Rows Fetched and Status Number of Rows Fetched and Status
Numeric Functions Numeric Functions
Numeric Literal Syntax Numeric Literal Syntax
Numeric Literals Numeric Literals

O

Obtaining Descriptor Handles Obtaining Descriptor Handles
ODBC and SQL-92 Scalar Functions ODBC and SQL-92 Scalar Functions
ODBC and the Standard CLI ODBC and the Standard CLI
ODBC API Reference ODBC API Reference
ODBC Architecture ODBC Architecture
ODBC Core Subkey ODBC Core Subkey
ODBC Cursor Library ODBC Cursor Library
ODBC Cursor Library Error Codes ODBC Cursor Library Error Codes
ODBC Data Sources Subkey ODBC Data Sources Subkey
ODBC Drivers Subkey ODBC Drivers Subkey
ODBC Error Codes ODBC Error Codes
ODBC Escape Sequences ODBC Escape Sequences
ODBC Function Summary ODBC Function Summary
ODBC Functions ODBC Functions
ODBC Functions Executed by the Cursor Library ODBC Functions Executed by the Cursor Library
ODBC Functions Not Executed by the Cursor Library ODBC Functions Not Executed by the Cursor Library
ODBC Fundamentals ODBC Fundamentals
ODBC in Windows ODBC in Windows
ODBC SQL Grammar ODBC SQL Grammar
ODBC State Transition Tables ODBC State Transition Tables
ODBC Subkey ODBC Subkey
ODBC Translators Subkey ODBC Translators Subkey
Optimistic Concurrency Optimistic Concurrency
Ordinary Arguments Ordinary Arguments
Organization of this Manual Organization of this Manual
Other Driver Architectures Other Driver Architectures
Outer Join Escape Sequence Outer Join Escape Sequence
Outer Joins Outer Joins
Overriding Default Leading and Seconds Precision for Interval Data Types Overriding Default Leading and Seconds Precision for Interval Data Types
Overriding Default Precision and Scale for Numeric Data Types Overriding Default Precision and Scale for Numeric Data Types
Overview Overview

P

Parameter Binding Offsets Parameter Binding Offsets
Parameter Data Types Parameter Data Types
Parameter Markers Parameter Markers
Parameter Markers in Procedure Calls Parameter Markers in Procedure Calls
Pattern Value Arguments Pattern Value Arguments
Positioned Update and Delete Statements Positioned Update and Delete Statements
Prepared Execution Prepared Execution
Procedure Call Escape Sequence Procedure Call Escape Sequence
Procedure Calls Procedure Calls
Procedure Parameters Procedure Parameters
Procedures Procedures
Processing an SQL Statement Processing an SQL Statement
Processing Batches of SQL Statements Processing Batches of SQL Statements
Processing Positioned Update and Delete Statements Processing Positioned Update and Delete Statements
Processing SELECT FOR UPDATE Statements Processing SELECT FOR UPDATE Statements
Processing SQL Statements Processing SQL Statements
Programming Considerations Programming Considerations
Prompting the User for Connection Information Prompting the User for Connection Information
Pseudo Type Identifiers Pseudo Type Identifiers

Q

Quoted Identifiers Quoted Identifiers

R

Recommended Reading Recommended Reading
Record Count Record Count
Redistributable Files Redistributable Files
Registry Entries for Data Sources Registry Entries for Data Sources
Registry Entries for ODBC Components Registry Entries for ODBC Components
Relative and Absolute Scrolling Relative and Absolute Scrolling
Result Set Metadata Result Set Metadata
Result-Generating and Result-Free Statements Result-Generating and Result-Free Statements
Retrieving Bookmarks Retrieving Bookmarks
Retrieving Data Type Information with SQLGetTypeInfo Retrieving Data Type Information with SQLGetTypeInfo
Retrieving Output Parameters by SQLGetData Retrieving Output Parameters by SQLGetData
Retrieving Results (Advanced) Retrieving Results (Advanced)
Retrieving Results (Basic) Retrieving Results (Basic)
Retrieving the Values in Descriptor Fields Retrieving the Values in Descriptor Fields
Return Codes Return Codes
Returning SQL_NO_DATA Returning SQL_NO_DATA
Role of the Driver Role of the Driver
Role of the Driver Manager Role of the Driver Manager
Row Status Row Status
Row Status Array Row Status Array
Rowset Size Rowset Size
Row-Wise Binding Row-Wise Binding
Rules for Conversions Rules for Conversions

S

Scalar Function Calls Scalar Function Calls
Scalar Function Escape Sequence Scalar Function Escape Sequence
Scalar Functions Scalar Functions
Schema Views Schema Views
Scrollable Cursor Types Scrollable Cursor Types
Scrollable Cursors Scrollable Cursors
Scrollable Cursors and Transaction Isolation Scrollable Cursors and Transaction Isolation
Scrolling and Fetching Rows Scrolling and Fetching Rows
Scrolling by Bookmark Scrolling by Bookmark
Sending Long Data Sending Long Data
Sequence of Status Records Sequence of Status Records
Serializability Serializability
Setting Descriptor Fields Setting Descriptor Fields
Setting Parameter Values Setting Parameter Values
Setting the Commit Mode Setting the Commit Mode
Setting the Transaction Isolation Level Setting the Transaction Isolation Level
Setting Up the Cursor Setting Up the Cursor
Setup DLL API Reference Setup DLL API Reference
Setup DLL Function Summary Setup DLL Function Summary
Setup Program Setup Program
Simulating Positioned Update and Delete Statements Simulating Positioned Update and Delete Statements
SQL Conformance Levels SQL Conformance Levels
SQL Data Types SQL Data Types
SQL Data Types in ODBC SQL Data Types in ODBC
SQL Grammar SQL Grammar
SQL Minimum Grammar SQL Minimum Grammar
SQL Modules SQL Modules
SQL Server Browsing Example SQL Server Browsing Example
SQL Statements SQL Statements
SQL Statements Constructed at Run Time SQL Statements Constructed at Run Time
SQL Statements Entered by the User SQL Statements Entered by the User
SQL to C Data Conversion Examples SQL to C Data Conversion Examples
SQL to C: Binary SQL to C: Binary
SQL to C: Bit SQL to C: Bit
SQL to C: Character SQL to C: Character
SQL to C: Date SQL to C: Date
SQL to C: Day-Time Intervals SQL to C: Day-Time Intervals
SQL to C: Numeric SQL to C: Numeric
SQL to C: Time SQL to C: Time
SQL to C: Timestamp SQL to C: Timestamp
SQL to C: Year-Month Intervals SQL to C: Year-Month Intervals
SQL Type Identifiers SQL Type Identifiers
SQL_ARD_TYPE SQL_ARD_TYPE
SQL_NO_DATA SQL_NO_DATA
SQL-92 Cast Function SQL-92 Cast Function
SQLAllocConnect SQLAllocConnect
SQLAllocConnect Mapping SQLAllocConnect Mapping
SQLAllocEnv SQLAllocEnv
SQLAllocEnv Mapping SQLAllocEnv Mapping
SQLAllocHandle SQLAllocHandle
SQLAllocStmt SQLAllocStmt
SQLAllocStmt Mapping SQLAllocStmt Mapping
SQLBindCol SQLBindCol
SQLBindCol in the Cursor Library SQLBindCol in the Cursor Library
SQLBindParam Mapping SQLBindParam Mapping
SQLBindParameter SQLBindParameter
SQLBindParameter in the Cursor Library SQLBindParameter in the Cursor Library
SQLBrowseConnect SQLBrowseConnect
SQLBulkOperations SQLBulkOperations
SQLBulkOperations and the Cursor Library SQLBulkOperations and the Cursor Library
SQLCancel SQLCancel
SQLCloseCursor SQLCloseCursor
SQLCloseCursor in the Cursor Library SQLCloseCursor in the Cursor Library
SQLColAttribute SQLColAttribute
SQLColAttributes SQLColAttributes
SQLColAttributes Mapping SQLColAttributes Mapping
SQLColumnPrivileges SQLColumnPrivileges
SQLColumns SQLColumns
SQLConfigDataSource SQLConfigDataSource
SQLConfigDriver SQLConfigDriver
SQLConnect SQLConnect
SQLCopyDesc SQLCopyDesc
SQLCreateDataSource SQLCreateDataSource
SQLDataSources SQLDataSources
SQLDataSourceToDriver SQLDataSourceToDriver
SQLDescribeCol SQLDescribeCol
SQLDescribeCol and SQLColAttribute SQLDescribeCol and SQLColAttribute
SQLDescribeParam SQLDescribeParam
SQLDisconnect SQLDisconnect
SQLDriverConnect SQLDriverConnect
SQLDrivers SQLDrivers
SQLDriverToDataSource SQLDriverToDataSource
SQLEndTran SQLEndTran
SQLEndTran in the Cursor Library SQLEndTran in the Cursor Library
SQLError SQLError
SQLError Mapping SQLError Mapping
SQLExecDirect SQLExecDirect
SQLExecute SQLExecute
SQLExtendedFetch SQLExtendedFetch
SQLExtendedFetch in the Cursor Library SQLExtendedFetch in the Cursor Library
SQLFetch SQLFetch
SQLFetch in the Cursor Library SQLFetch in the Cursor Library
SQLFetchScroll SQLFetchScroll
SQLFetchScroll in the Cursor Library SQLFetchScroll in the Cursor Library
SQLForeignKeys SQLForeignKeys
SQLFreeConnect SQLFreeConnect
SQLFreeConnect Mapping SQLFreeConnect Mapping
SQLFreeEnv SQLFreeEnv
SQLFreeEnv Mapping SQLFreeEnv Mapping
SQLFreeHandle SQLFreeHandle
SQLFreeStmt SQLFreeStmt
SQLFreeStmt in the Cursor Library SQLFreeStmt in the Cursor Library
SQLFreeStmt Mapping SQLFreeStmt Mapping
SQLGetConfigMode SQLGetConfigMode
SQLGetConnectAttr SQLGetConnectAttr
SQLGetConnectOption SQLGetConnectOption
SQLGetConnectOption Mapping SQLGetConnectOption Mapping
SQLGetCursorName SQLGetCursorName
SQLGetData SQLGetData
SQLGetData and Block Cursors SQLGetData and Block Cursors
SQLGetData in the Cursor Library SQLGetData in the Cursor Library
SQLGetDescField SQLGetDescField
SQLGetDescField and SQLGetDescRec in the Cursor Library SQLGetDescField and SQLGetDescRec in the Cursor Library
SQLGetDescRec SQLGetDescRec
SQLGetDiagField SQLGetDiagField
SQLGetDiagRec SQLGetDiagRec
SQLGetEnvAttr SQLGetEnvAttr
SQLGetFunctions SQLGetFunctions
SQLGetFunctions in the Cursor Library SQLGetFunctions in the Cursor Library
SQLGetInfo SQLGetInfo
SQLGetInfo in the Cursor Library SQLGetInfo in the Cursor Library
SQLGetInfo Support SQLGetInfo Support
SQLGetInstalledDrivers SQLGetInstalledDrivers
SQLGetPrivateProfileString SQLGetPrivateProfileString
SQLGetStmtAttr SQLGetStmtAttr
SQLGetStmtAttr in the Cursor Library SQLGetStmtAttr in the Cursor Library
SQLGetStmtOption SQLGetStmtOption
SQLGetStmtOption in the Cursor Library SQLGetStmtOption in the Cursor Library
SQLGetStmtOption Mapping SQLGetStmtOption Mapping
SQLGetTranslator SQLGetTranslator
SQLGetTypeInfo SQLGetTypeInfo
SQLInstallDriverEx SQLInstallDriverEx
SQLInstallDriverManager SQLInstallDriverManager
SQLInstallerError SQLInstallerError
SQLInstallTranslator SQLInstallTranslator
SQLInstallTranslator Mapping SQLInstallTranslator Mapping
SQLInstallTranslatorEx SQLInstallTranslatorEx
SQLManageDataSources SQLManageDataSources
SQLMoreResults SQLMoreResults
SQLNativeSql SQLNativeSql
SQLNativeSql in the Cursor Library SQLNativeSql in the Cursor Library
SQLNumParams SQLNumParams
SQLNumResultCols SQLNumResultCols
SQLParamData SQLParamData
SQLParamOptions SQLParamOptions
SQLParamOptions Mapping SQLParamOptions Mapping
SQLPostInstallerError SQLPostInstallerError
SQLPrepare SQLPrepare
SQLPrimaryKeys SQLPrimaryKeys
SQLProcedureColumns SQLProcedureColumns
SQLProcedures SQLProcedures
SQLPutData SQLPutData
SQLReadFileDSN SQLReadFileDSN
SQLRemoveDefaultDataSource SQLRemoveDefaultDataSource
SQLRemoveDriver SQLRemoveDriver
SQLRemoveDriverManager SQLRemoveDriverManager
SQLRemoveDSNFromIni SQLRemoveDSNFromIni
SQLRemoveTranslator SQLRemoveTranslator
SQLRowCount SQLRowCount
SQLRowCount in the Cursor Library SQLRowCount in the Cursor Library
SQLSetConfigMode SQLSetConfigMode
SQLSetConnectAttr SQLSetConnectAttr
SQLSetConnectAttr in the Cursor Library SQLSetConnectAttr in the Cursor Library
SQLSetConnectOption SQLSetConnectOption
SQLSetConnectOption Mapping SQLSetConnectOption Mapping
SQLSetCursorName SQLSetCursorName
SQLSetDescField SQLSetDescField
SQLSetDescField and SQLSetDescRec in the Cursor Library SQLSetDescField and SQLSetDescRec in the Cursor Library
SQLSetDescRec SQLSetDescRec
SQLSetEnvAttr SQLSetEnvAttr
SQLSetEnvAttr and the Cursor Library SQLSetEnvAttr and the Cursor Library
SQLSetParam SQLSetParam
SQLSetParam Mapping SQLSetParam Mapping
SQLSetPos SQLSetPos
SQLSetPos in the Cursor Library SQLSetPos in the Cursor Library
SQLSetScrollOptions SQLSetScrollOptions
SQLSetScrollOptions in the Cursor Library SQLSetScrollOptions in the Cursor Library
SQLSetScrollOptions Mapping SQLSetScrollOptions Mapping
SQLSetStmtAttr SQLSetStmtAttr
SQLSetStmtAttr in the Cursor Library SQLSetStmtAttr in the Cursor Library
SQLSetStmtOption SQLSetStmtOption
SQLSetStmtOption Mapping SQLSetStmtOption Mapping
SQLSpecialColumns SQLSpecialColumns
SQLSTATE Mappings SQLSTATE Mappings
SQLSTATEs SQLSTATEs
SQLStatistics SQLStatistics
SQLTablePrivileges SQLTablePrivileges
SQLTables SQLTables
SQLTransact SQLTransact
SQLTransact Mapping SQLTransact Mapping
SQLValidDSN SQLValidDSN
SQLWriteDSNToIni SQLWriteDSNToIni
SQLWriteFileDSN SQLWriteFileDSN
SQLWritePrivateProfileString SQLWritePrivateProfileString
Standard Data Stream Protocol Standard Data Stream Protocol
Standard Database Access Architectures Standard Database Access Architectures
Standard Gateway Standard Gateway
Standard Programming Interface Standard Programming Interface
standards-compliant applications and drivers Standards-Compliant Applications and Drivers
State Transition Checks State Transition Checks
State Transitions State Transitions
Statement Attributes Statement Attributes
Statement Handles Statement Handles
Statement Parameters Statement Parameters
Statement Transitions Statement Transitions
Static Cursors Static Cursors
Static SQL Static SQL
Status Records Status Records
Step 1: Connect to the Data Source Step 1: Connect to the Data Source
Step 2: Initialize the Application Step 2: Initialize the Application
Step 3: Build and Execute an SQL Statement Step 3: Build and Execute an SQL Statement
Step 4a: Fetch the Results Step 4a: Fetch the Results
Step 4b: Fetch the Row Count Step 4b: Fetch the Row Count
Step 5: Commit the Transaction Step 5: Commit the Transaction
Step 6: Disconnect from the Data Source Step 6: Disconnect from the Data Source
String Functions String Functions
Structured Query Language (SQL) Structured Query Language (SQL)
Supported Data Types Supported Data Types
System Functions System Functions

T

Tables and Views Tables and Views
Testing Interoperable Applications Testing Interoperable Applications
The Driver Manager The Driver Manager
The Installer DLL The Installer DLL
The ODBC Cursor Library The ODBC Cursor Library
The ODBC Solution The ODBC Solution
Time, Date, and Interval Functions Time, Date, and Interval Functions
Trace DLL Trace DLL
Trace File Trace File
Tracing Tracing
Transaction Isolation Transaction Isolation
Transaction Isolation Levels Transaction Isolation Levels
Transaction Support Transaction Support
Transaction Support in DBMSs Transaction Support in DBMSs
Transactions Transactions
Transactions in ODBC Transactions in ODBC
Transfer Octet Length Transfer Octet Length
Transferring Data in its Binary Form Transferring Data in its Binary Form
Translation DLL Function Reference Translation DLL Function Reference
Translation DLL Function Summary Translation DLL Function Summary
Translation DLLs Translation DLLs
Translator Setup DLLs Translator Setup DLLs
Translator Specification Subkeys Translator Specification Subkeys
Type Identifiers Type Identifiers
Types of Applications Types of Applications
Types of Changes Types of Changes
Types of Data Sources Types of Data Sources
Types of Descriptors Types of Descriptors
Types of Drivers Types of Drivers

U

UPDATE, DELETE, and INSERT Statements UPDATE, DELETE, and INSERT Statements
Updating Data Updating Data
Updating Data with SQLBulkOperations Updating Data with SQLBulkOperations
Updating Data with SQLSetPos Updating Data with SQLSetPos
Updating Rows by Bookmark with SQLBulkOperations Updating Rows by Bookmark with SQLBulkOperations
Updating Rows in the Rowset with SQLSetPos Updating Rows in the Rowset with SQLSetPos
Updating, Deleting, or Fetching by Bookmark Updating, Deleting, or Fetching by Bookmark
Usage Counting Usage Counting
Uses of Catalog Data Uses of Catalog Data
Using Arrays of Parameters Using Arrays of Parameters
Using Block Cursors Using Block Cursors
Using Concise Functions Using Concise Functions
Using Data Buffers Using Data Buffers
Using Data Sources Using Data Sources
Using Data Type Identifiers Using Data Type Identifiers
Using Length/Indicator Values Using Length/Indicator Values
Using Scrollable Cursors Using Scrollable Cursors
Using SQLBindCol Using SQLBindCol
Using SQLGetDiagRec and SQLGetDiagField Using SQLGetDiagRec and SQLGetDiagField
Using the ODBC Cursor Library Using the ODBC Cursor Library

V

Value List Arguments Value List Arguments
Version Number Version Number
Vertical Applications Vertical Applications

W

Was a Result Set Created? Was a Result Set Created?
What is ODBC? What is ODBC?
What the Driver Does What the Driver Does
What the Driver Manager Does What the Driver Manager Does
When to Use Procedures When to Use Procedures
Why Was ODBC Created? Why Was ODBC Created?
Writing an Interoperable Application Writing an Interoperable Application
Writing ODBC 3.0 Applications Writing ODBC 3.0 Applications
Writing ODBC 3.0 Drivers Writing ODBC 3.0 Drivers