Database Access

Table of Contents

Index

Appendix C: DataDirect ODBC Drivers

• C.1 The UNIX Environment
  • C.1.1 The System Information File (.odbc.ini)
    • C.1.1.1 Sample System Information File for Solaris
  • C.1.2 Environment Variables
    • C.1.2.1 Required Environment Variables
    • C.1.2.2 Optional Environment Variables
  • C.1.3 Using Double-Byte Character Sets
    • C.1.3.1 The ivtestlib Tool
  • C.1.4 Translators
• C.2 Connect ODBC for DB2
  • C.2.1 System Requirements
  • C.2.2 DB2 Binding and Priviliges
    • C.2.2.1 Binding
  • C.2.3 Configuring and Connecting to Data Sources
  • C.2.4 Data Types
  • C.2.5 Isolation and Lock Levels Supported
  • C.2.6 ODBC Conformance Level
  • C.2.7 Number of Connections and Statements Supported
• C.3 Connect ODBC for dBASE
  • C.3.1 System Requirements
  • C.3.2 Defining Index Attributes on UNIX Platforms
  • C.3.3 Configuring and Connecting to Data Sources
  • C.3.4 Data Types
  • C.3.5 Column Names
  • C.3.6 SELECT Statement
    • C.3.6.1 Rowid Pseudo-Column
  • C.3.7 ALTER TABLE Statement
  • C.3.8 CREATE INDEX Statement
  • C.3.9 DROP INDEX Statement
  • C.3.10 PACK Statement
  • C.3.11 Locking
    • C.3.11.1 Levels of Database Locking
    • C.3.11.2 Limit on Number of Locks
    • C.3.11.3 How Transactions Affect Record Locks
  • C.3.12 Isolation and Lock Levels Supported
  • C.3.13 ODBC Conformance Level
  • C.3.14 Number of Connections and Statements Supported
• C.4 Connect ODBC for INFORMIX
  • C.4.1 System Requirements
  • C.4.2 Configuring and Connecting to Data Sources
  • C.4.3 Data Types
    • C.4.3.1 INFORMIX 9
  • C.4.4 Isolation and Lock Levels Supported
  • C.4.5 ODBC Conformance Level
  • C.4.6 Number of Connections and Statements Supported
• C.5 Connect ODBC for OpenIngres
  • C.5.1 System Requirements
  • C.5.2 Configuring and Connecting to Data Sources
  • C.5.3 Data Types
  • C.5.4 Isolation and Lock Levels Supported
  • C.5.5 ODBC Conformance Level
  • C.5.6 Number of Connections and Statements Supported
• C.6 Connect ODBC for Oracle
  • C.6.1 System Requirements
  • C.6.2 Configuring and Connecting to Data Sources
    • C.6.2.1 Connecting via Operating System Parameters
  • C.6.3 Oracle Data Types
  • C.6.4 Stored Procedure Results
  • C.6.5 Isolation and Lock Levels Supported
  • C.6.6 ODBC Conformance Level
  • C.6.7 Number of Connections and Statements Supported
• C.7 Connect ODBC for Sybase
  • C.7.1 System Requirements
  • C.7.2 Configuring and Connecting to Data Sources
  • C.7.3 Data Types
  • C.7.4 Isolation and Lock Levels Supported
  • C.7.5 ODBC Conformance Level
  • C.7.6 Number of Connections and Statements Supported
• C.8 Connect ODBC for Text
  • C.8.1 Formats for Text Files
  • C.8.2 Defining Table Structure on UNIX Platforms
    • C.8.2.1 Example of QETXT.INI
  • C.8.3 Date Masks
  • C.8.4 Configuring and Connecting to Data Sources
  • C.8.5 Data Types
  • C.8.6 SELECT Statement
  • C.8.7 ALTER TABLE Statement
  • C.8.8 ODBC Conformance Level
  • C.8.9 Number of Connections and Statements Supported