Home | Previous Page | Next Page

Contents

In This Introduction

About This Manual

Software Dependencies

Assumptions About Your Locale

Demonstration Databases

Documentation Conventions

Typographical Conventions

Feature, Product, and Platform

Syntax Diagrams

Example Code Conventions

Additional Documentation

Installation Guides

Informix Error Messages

IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set

Compliance with Industry Standards

IBM Welcomes Your Comments

Overview of IBM Informix ODBC Driver

In This Chapter

What is IBM Informix ODBC Driver?

IBM Informix ODBC Driver Features

Additional Values for Some ODBC Function Arguments

ODBC Component Overview

IBM Informix ODBC Driver with a Driver Manager

IBM Informix ODBC Driver Without a Driver Manager (UNIX)

IBM Informix ODBC Driver with the DMR

Using IBM Informix ODBC Driver

Environment Variables

Using the IBM Informix ODBC Driver API

Environment, Connection, and Statement Handles

SQLGetInfo Argument Implementation

Global Language Support

Database Locale

Translation Library

Translation Option

X/Open Standard Interface

External Authentication

Pluggable Authentication Module (PAM) on UNIX and Linux

LDAP Authentication on Windows

Using the SQLSetConnectAttr() function with Authentication

Partially Supported and Unsupported ODBC Features

Transaction Processing

SQLBulkOperations

SQLDescribeParam

Unsupported Microsoft ODBC Driver Features

Configuring Data Sources

In This Chapter

Configuring a DSN on UNIX

The sqlhosts File

The odbcinst.ini File

The odbc.ini File

Setting the $ODBCINI Environment Variable

The .netrc File

Configuring a DSN in Windows

Making a Connection Without DSN

In This Chapter

Standard SQL Data Types

Additional SQL Data Types for GLS

Additional SQL Data Types for Dynamic Server

Precision, Scale, Length, and Display Size

C Interval Structure

Transferring Data

Reporting Standard ODBC Types

SQL_INFX_ATTR_ODBC_TYPES_ONLY

SQL_INFX_ATTR_LO_AUTOMATIC

SQL_INFX_ATTR_DEFAULT_UDT_FETCH_TYPE

Reporting Wide Character Columns

DSN Settings for Report Standard ODBC Data Types

Converting Data

Standard Conversions

Additional Conversions for GLS

Additional Conversions for Dynamic Server

Converting Data from SQL to C

Converting Data from C to SQL

Working with Smart Large Objects

In This Chapter

Working with Data Structures for Smart Large Objects

Handling the Storage of Smart Large Objects

Disk-Storage Information

Create-Time Flags

Inheritance Hierarchy

Creating a Smart Large Object

Transferring Smart-Large-Object Data

Accessing a Smart Large Object

Smart-Large-Object Automation

Using ifx_lo Functions

Retrieving the Status of a Smart Large Object

Example of Retrieving Information About a Smart Large Object

Reading or Writing a Smart Large Object to or from a File

Working with Rows and Collections

In This Chapter

Transferring Row and Collection Data

Fixed-Type Buffers and Unfixed-Type Buffers

Buffers and Memory Allocation

Example of Retrieving Row and Collection Data from the Database

Creating a Row or Collection

Example of Creating a Row and a List on the Client

Modifying a Row or Collection

Retrieving Information About a Row or Collection

Client Functions

In This Chapter

Calling a Client Function

Function Syntax

Input and Output Parameters

Functions for Smart Large Objects

ifx_lo_col_info()

ifx_lo_create()

ifx_lo_def_create_spec()

ifx_lo_readwithseek()

ifx_lo_specget_estbytes()

ifx_lo_specget_extsz()

ifx_lo_specget_flags()

ifx_lo_specget_maxbytes()

ifx_lo_specget_sbspace()

ifx_lo_specset_estbytes()

ifx_lo_specset_extsz()

ifx_lo_specset_flags()

ifx_lo_specset_maxbytes()

ifx_lo_specset_sbspace()

ifx_lo_stat_atime()

ifx_lo_stat_cspec()

ifx_lo_stat_ctime()

ifx_lo_stat_refcnt()

ifx_lo_stat_size()

ifx_lo_truncate()

ifx_lo_writewithseek()

Functions for Rows and Collections

ifx_rc_create()

ifx_rc_delete()

ifx_rc_describe()

ifx_rc_insert()

ifx_rc_isnull()

ifx_rc_setnull()

ifx_rc_typespec()

ifx_rc_update()

Improving Application Performance

In This Chapter

Case-Sensitive Catalog Functions

Connection Level Optimizations

Optimizing Query Execution

Inserting Multiple Rows

Automatically Freeing a Cursor

Enabling the AUTOFREE Feature

Using the AUTOFREE Feature

Delaying Execution of the SQLPREPARE Statement

Setting the Fetch Array Size for Simple-Large-Object Data

Using the SPL Output Parameter Feature

Using Asynchronous Execution

Updating Data with Positioned Updates and Deletes

Message Transfer Optimization

Message Chaining Restrictions

Disabling Message Chaining

Handling Errors with Optimized Message Transfers

In This Chapter

Diagnostic SQLSTATE Values

Mapping SQLSTATE Values to Informix Error Messages

Mapping Informix Error Messages to SQLSTATE Values

SQLAllocConnect (Core Level Only)

SQLAllocEnv (Core Level Only)

SQLAllocStmt (Core Level Only)

SQLBindCol (Core Level Only)

SQLBindParameter (Level One Only)

SQLBrowseConnect (Level Two Only)

SQLCancel (Core Level Only)

SQLColAttributes (Core Level Only)

SQLColumnPrivileges (Level Two Only)

SQLColumns (Level One Only)

SQLConnect (Core Level Only)

SQLDataSources (Level Two Only)

SQLDescribeCol (Core Level Only)

SQLDriverConnect (Level One Only)

SQLDrivers (Level Two Only)

SQLError (Core Level Only)

SQLExecDirect (Core Level Only)

SQLExecute (Core Level Only)

SQLExtendedFetch (Level Two Only)

SQLFetch (Core Level Only)

SQLForeignKeys (Level Two Only)

SQLFreeConnect (Core Level Only)

SQLFreeEnv (Core Level Only)

SQLFreeStmt (Core Level Only)

SQLGetConnectOption (Level One Only)

SQLGetCursorName (Core Level Only)

SQLGetData (Level One Only)

SQLGetFunctions (Level One Only)

SQLGetInfo (Level One Only)

SQLGetStmtOption (Level One Only)

SQLGetTypeInfo (Level One Only)

SQLMoreResults (Level Two Only)

SQLNativeSql (Level Two Only)

SQLNumParams (Level Two Only)

SQLNumResultCols (Core Level Only)

SQLParamData (Level One Only)

SQLParamOptions (Core and Level Two Only)

SQLPrimaryKeys (Level Two Only)

SQLProcedureColumns (Level Two Only)

SQLProcedures (Level Two Only)

SQLPutData (Level One Only)

SQLRowCount (Core Level Only)

SQLSetConnectOption (Level One Only)

SQLSetCursorName (Core Level Only)

SQLSetStmtOption (Level One Only)

SQLSpecialColumns (Level One Only)

SQLStatistics (Level One Only)

SQLTablePrivileges (Level Two Only)

SQLTables (Level One Only)

SQLTransact (Core Level Only)

In This Chapter

Overview of Unicode

Unicode versions

Unicode in an ODBC Application

Using Unicode in an ODBC Application

Unicode Functions Supported

Appendix. Accessibility

Dotted Decimal Syntax Diagrams

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]