Index

• .h files.
  • See also Header files.
• .netrc file

• Accessibility
  • dotted decimal format of syntax diagrams
  • syntax diagrams, reading in a screen reader
• Allocating handles.
  • See also Connection handles; Environment handles; Statement handles.
• Architecture
• Arguments
  • See also Parameters.
  • null pointers
  • pointers
• Arrays.
  • See also Binding columns; Parameters, arrays.
• Attributes, columns
• Auto-commit mode.
  • See also Transactions.
• AUTOFREE feature

• Binary data
  • C data type
  • converting to C
  • converting to SQL
  • transferring
• Binding columns (1), (2), (3)
  • See also Converting data; Rowsets.
• Binding parameters.
  • See also Parameters, binding.
• Bit data, converting to SQL
• BLOB data type
• Boldface type
• Bookmarks, support
• Boolean data
  • C data type
  • converting to C
• BOOLEAN data type
• Boundaries, segment
• Buffers
  • See also NULL data; Null-termination byte.
  • allocating
  • input (1), (2)
  • interoperability
  • maintaining pointers
  • NULL data
  • null pointers
  • null-termination
  • output (1), (2)
  • segment boundaries
  • truncating data
• Bulk operations
• BYTE data type

• C data type
  • See also Converting data; SQL data types.
  • binary
  • boolean
  • character
  • conversion examples (1), (2)
  • converting from SQL data type (1), (2)
  • converting to SQL data types
  • date
  • default conversions
  • Informix ODBC Driver
  • numeric
  • SQL_C_BINARY
  • SQL_C_BIT
  • SQL_C_CHAR
  • SQL_C_DATE
  • SQL_C_DOUBLE
  • SQL_C_FLOAT
  • SQL_C_LONG
  • SQL_C_SHORT
  • SQL_C_SLONG
  • SQL_C_SSHORT
  • SQL_C_STINYINT
  • SQL_C_TIMESTAMP
  • SQL_C_TINYINT
  • SQL_C_ULONG
  • SQL_C_USHORT
  • SQL_C_UTINYINT
  • standard
  • timestamp
  • typedefs
• Calls, executing with SQLPrepare and SQLExecute
• Canceling, connection browsing
• Case-sensitive catalog functions
• Catalog functions, case-sensitive
• Challenge and response buffer pointers
• CHAR data type
• Character data
  • converting to C
  • converting to SQL
  • empty string
• CHARACTER data type
• CHARACTER VARYING data type (1), (2)
• Characters, special
• Client functions, calling (1), (2)
• Client locale
• CLIENT_LOCALE environment variable (1), (2)
• CLOB data types
• Code, example
  • See also specific function descriptions.
• Code, sample, conventions for
• Collections
  • buffers
  • converting SQL data
  • creating (1), (2)
  • current position
  • deleting (1), (2)
  • inserting (1), (2)
  • local fetch
  • modifying
  • retrieving
  • retrieving information
  • transferring
  • updating (1), (2)
• Columns
  • See also Result sets; SQL data types; Table.
  • attributes
  • binding.
    • See also Binding columns.
  • precision.
    • See also Precision.
  • procedure
• Command-line conventions
  • how to read
  • sample diagram
• Compliance
  • with industry standards
• Concurrency
• Configuring a DSN on
  • UNIX
• Configuring a DSN on Windows
• Configuring data sources.
  • See also Data sources, configuring.
• Connection handles
  • defined connection handles
    • HDBC variable type
  • SQLFreeConnect
• Connections, SQLDisconnect
• Contact information
• Conventions
  • command-line
  • documentation
  • sample-code
  • syntax diagrams
  • syntax notation
  • typographical
• Converting data
  • See also Translation, shared library.
  • C to SQL
  • default conversions
  • examples (1), (2)
  • hexadecimal characters
  • SQL to C
• Create-time flags
• Cursor
  • automatically freeing
  • enable insert cursor
  • insert
  • position errors
  • Report KeySet
  • scrollable

• Data
  • committing
  • converting
    • See also Converting data.
  • length
  • transferring in binary form
  • translating.
    • See also Translation, shared library.
  • truncating.
    • See also Truncating data.
  • updating
• Data-source specification
• Data sources
  • configuring on UNIX
  • configuring on Windows
• Data types.
  • See also C data type; SQL data types.
• Database locale
• Database server, client behavior on
• Date data
  • C data type
  • converting to C
  • converting to SQL
• DATE data type
• DATE_STRUCT typedef
• DATETIME data type
• DB_LOCALE environment variable (1), (2)
• DBCENTURY environment variable
• DBDATE environment variable
• DEC data type
• DECIMAL data type
• Default fetch type for UDTs
• Default locale
• DELETE statements (1), (2), (3)
  • See also SQLSetPos.
  • affected rows
• Demonstration databases
• Dependencies, software
• Descriptors, columns
• Diagnostics
• Disabilities, visual
  • reading syntax diagrams
• Disk-storage information
• Display size
• DISTINCT data type
• Documentation, types of
  • machine notes
  • online manuals
  • printed manuals
• Documentation conventions
• Documentation Notes
• Documentation set of all manuals
• Dotted decimal format of syntax diagrams
• DOUBLE PRECISION data type
• Driver, Informix ODBC
• Driver manager, described
• Drivers, allocating handles
• DSN settings

• Empty strings
• en_us.8859-1 locale
• Environment handles
  • defined
  • SQLAllocEnv
  • SQLFreeEnv
• Environment variables
  • CLIENT_LOCALE (1), (2)
  • DB_LOCALE (1), (2)
  • DBCENTURY
  • DBDATE
  • INFORMIXDIR
  • INFORMIXSQLHOSTS
  • ODBCINI
  • PATH
  • TRANSLATION_OPTION
  • TRANSLATIONDLL (1), (2)
  • VMBCHARLENEXACT
• Error messages
  • Informix
    • mapping SQLSTATE values
• Errors
  • See also specific function descriptions.
  • diagnostic SQLSTAGE values
  • error messages
  • handling with OPTMSG
  • mapping Informix to SQLSTATE values
  • rowsets
• Examples, data conversion (1), (2)
• Extended data types
• Extensive error detection
• External authentication

• fCType
• Features, new
• Fetch simple large object data
• Fetch type
• Fetching data.
  • See also Binding columns; Rowsets; Rows.
• Files
  • .h files.
    • See also Header files.
  • .netrc
  • infxcli.h (1), (2)
  • odbc.ini
  • odbcinst.ini
  • sqlhosts
• Fixed and Known Defects File
• FLOAT data type
• Floating point data
  • converting to C
  • converting to SQL
• Freeing handles.
  • See also Connection handles; Environment handles; Statement handles.
• Functions
  • catalog
  • rows and collections
    • ifx_rc_count()
    • ifx_rc_create()
    • ifx_rc_delete()
    • ifx_rc_describe()
    • ifx_rc_fetch()
    • ifx_rc_free()
    • ifx_rc_insert()
    • ifx_rc_isnull()
    • ifx_rc_setnull()
    • ifx_rc_typespec()
    • ifx_rc_update()
  • smart large objects
    • ifx_lo_alter()
    • ifx_lo_close()
    • ifx_lo_col_info()
    • ifx_lo_create()
    • ifx_lo_def_create_spec()
    • ifx_lo_open()
    • ifx_lo_read()
    • ifx_lo_readwithseek()
    • ifx_lo_seek()
    • 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()
    • ifx_lo_stat_atime()
    • ifx_lo_stat_cspec()
    • ifx_lo_stat_ctime()
    • ifx_lo_stat_refcnt()
    • ifx_lo_stat_size()
    • ifx_lo_tell()
    • ifx_lo_truncate()
    • ifx_lo_write()
    • ifx_lo_writewithseek()

• Global Language Support
• GLS
  • data types (1), (2)
• GLS.
  • See also Global Language Support.

• Handles.
  • See also Connection handles; Environment handles; Statement handles.
• hdbc.
  • See also Connection handles.
• Header files
  • required
  • sqlext.h C data type
• Help
• henv.
  • See also Environment handles.
• Hexadecimal characters
• hstmt.
  • See also Statement handles.

• ifx_lo_alter()
• ifx_lo_close()
• ifx_lo_col_info()
• ifx_lo_create()
• ifx_lo_def_create_spec()
• ifx_lo_open()
• ifx_lo_read()
• ifx_lo_readwithseek()
• ifx_lo_seek()
• 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()
• ifx_lo_stat_atime()
• ifx_lo_stat_cspec()
• ifx_lo_stat_ctime()
• ifx_lo_stat_refcnt()
• ifx_lo_stat_size()
• ifx_lo_tell()
• ifx_lo_truncate()
• ifx_lo_write()
• ifx_lo_writewithseek()
• ifx_rc_count()
• ifx_rc_create()
• ifx_rc_delete()
• ifx_rc_describe()
• ifx_rc_fetch()
• ifx_rc_free()
• ifx_rc_insert()
• ifx_rc_isnull()
• ifx_rc_setnull()
• ifx_rc_typespec()
• ifx_rc_update()
• Include files.
  • See also Header files.
• Industry standards, compliance with
• Informix Dynamic Server documentation set
• INFORMIXDIR environment variable
• INFORMIXSQLHOSTS environment variable
• INFX_LO_AUTOMATIC_ATTR
• infxcli.h file
• Initializing data sources
• Input buffers
• Insert cursor
  • enabling
• INSERT statements
  • affected rows (1), (2)
  • SQLParamOptions
• INSERT statements.
  • See also SQLSetPos.
• Installation Guides
• INT data type
• INT8 data type
• Integer data
  • converting to C
  • converting to SQL
• INTEGER data type
• Internet Protocol Version 6
• Interoperability
  • buffer length
  • default C data type
  • transferring data
• ISO 8859-1 code set

• Keywords
  • in syntax diagrams

• LDAP authentication on Windows
• Length
  • data
• Length, buffers
  • input
  • maximum
  • output
• Length, defined
• Length, unknown
  • precision
• Libraries
• Library
  • Informix ODBC Driver
  • translation
    • shared
• LIST data type
• LO_APPEND
• LO_BUFFER
• LO_DIRTY_READ
• LO_KEEP_LASTACCESS_ TIME
• LO_LOG
• LO_NOBUFFER
• LO_NOKEEP_LASTACCESS_ TIME
• LO_NOLOG
• LO_RDONLY
• LO_RDWR
• LO_SEEK_CUR (1), (2), (3)
• LO_SEEK_END (1), (2), (3)
• LO_SEEK_SET (1), (2), (3)
• LO_WRONLY
• Locale
  • client
  • database
• lofd
• Login authorization.
  • See also Connections.
• Logon ID
• Long identifiers
• loptr
• lospec
• lostat
• LVARCHAR data type

• Machine notes
• Manual-commit mode.
  • See also Transactions.
• Memory.
  • See also Connection handles; Environment handles; Statement handles.
• Message chaining
• Message transfer optimization
• Messages, error.
  • See also Errors.
• Microsoft Transaction Server
• Migrating to Informix ODBC
  • DSN connection on UNIX (1), (2)
  • DSN connection on Windows
• Modes
  • auto-commit.
    • See also Transactions.
  • manual commit.
    • See also Transactions.
• MONEY data type
• MTS.
  • See also Microsoft Transaction Server.
• MULTISET data type
• Multithreading, with environment handles

• Named rows
• NCHAR data type
• New features
• NULL data
  • output buffers
• Null pointers
  • input buffers
  • output buffers
• Null-termination byte
  • embedded
  • examples (1), (2)
  • input buffers
  • output buffers
• Numeric data
  • See also Floating point data; Integer data.
  • C data type
  • converting to C
  • converting to SQL
• NUMERIC data type
• NVARCHAR data type

• odbc.ini file
  • Data Source Specification section
  • ODBC Data Sources section
• odbc.ini tracing options
• ODBCINI environment variable
• odbcinst.ini file
• Online help
• Online manuals
• Online notes (1), (2)
• OPAQUE data type
• Optimistic concurrency control.
  • See also Concurrency.
• OPTMSG
• Output buffers

• PAM.
  • See also Pluggable Authentication Module.
• Parameters
  • See also Arguments.
  • arrays
  • binding
    • SQLBindParameter
  • number
• Password
• PATH environment variable
• Pluggable Authentication Module
  • Connect functions
  • Connection pooling
  • Intermediate Code
  • SQLSetConnectAttr() function
  • Third party connections
• Pointers, maintaining
• Pointers, null.
  • See also Null pointers.
• Position, cursor.
  • See also Cursor.
• Positioned
  • DELETE statements
  • UPDATE statements
• Precision
• Printed manuals
• Procedure
  • defined
• Procedure columns
• Procedures, SQL
  • SQLSTAGE and error values
• pwd

• Queries.
  • See also SQL statements.

• REAL data type
• Release Notes
• Report KeySet cursors
• Report sets
  • SQLDescribeCol
• Report standard ODBC data type
  • DSN settings
• Result sets
  • See also Cursor; Rows.
  • arrays.
    • See also Rowsets.
  • defined
  • SQLNumResultCols
  • SQLRowCount (1), (2)
• Retrieving data
  • arrays.
    • See also Rowsets.
  • binding columns.
    • See also Binding columns.
  • rows.
    • See also Rows.
• Row status array, errors
• Rows (1), (2)
  • See also Cursor; Rowsets.
  • affected (1), (2)
  • and collections
  • buffers
  • converting SQL data
  • creating (1), (2)
  • current position
  • deleting (1), (2)
  • errors in
  • inserting (1), (2)
  • local fetch
  • modifying
  • retrieving
  • retrieving information
  • transferring
  • updating (1), (2)
• Rowsets
  • errors

• Sample-code conventions
• SBSPACENAME
• Scale, defined
• SCHAR typedef
• Screen reader
  • reading syntax diagrams
• Scrollable cursor
• SDOUBLE typedef
• SDWORD typedef
• Segment boundaries
• SELECT statements
  • See also Result sets.
  • affected rows (1), (2)
  • bulk
• SERIAL data type
• SERIAL8 data type
• SET data type
• setup.odbc
• SFLOAT typedef
• Simple large object fetches
• Size, display
• SMALLFLOAT data type
• SMALLINT data type
• Smart large objects
  • access modes
  • accessing
  • allocation extent size
  • altering
  • closing (1), (2)
  • creating (1), (2)
  • data structures
  • disk-storage information
  • estimated size
  • file descriptor
  • functions
  • getting file position
  • ifx_lo functions
  • inheritance hierarchy
  • inserting
  • last access-time
  • lightweight I/O
  • locks
  • logging indicator
  • maximum size
  • modifying
  • ODBC API
  • opening (1), (2)
  • pointer structure
  • reading (1), (2)
  • retrieving status
  • sbspace name
  • selecting
  • setting file position (1), (2)
  • specification structure
  • status structure
  • storage characteristics (1), (2)
  • transferring
  • updating
  • writing (1), (2)
• Software dependencies
• Special characters
• SQL_ATTR_ROW_ARRAY_SIZE
• SQL_BIGINT data type
• SQL_BIT data type
• SQL_C_BINARY data type
• SQL_C_BIT data type
• SQL_C_CHAR data type
• SQL_C_DATE data type
• SQL_C_DOUBLE data type
• SQL_C_FLOAT data type
• SQL_C_LONG data type
• SQL_C_SHORT data type
• SQL_C_SLONG data type
• SQL_C_SSHORT data type
• SQL_C_STINYINT data type
• SQL_C_TIMESTAMP data type
• SQL_C_TINYINT data type
• SQL_C_ULONG data type
• SQL_C_USHORT data type
• SQL_C_UTINYINT data type
• SQL_CHAR data type
• SQL code
• SQL data types
  • See also C data type; Converting data; SQL statements.
  • BLOB
  • BOOLEAN
  • BYTE
  • CHAR
  • CHARACTER
  • CHARACTER VARYING
  • CLOB
  • collection
  • conversion examples (1), (2)
  • converting from C data type
  • converting to C data type
  • DATE
  • DATETIME
  • DEC
  • DECIMAL
  • default C data type
  • display size
  • DISTINCT
  • DOUBLE PRECISION
  • FLOAT
  • Informix
  • Informix ODBC Driver
  • INT
  • INT8
  • INTEGER
  • length
  • LIST
  • LVARCHAR
  • MONEY
  • MULTISET
  • NCHAR
  • NUMERIC
  • NVARCHAR
  • OPAQUE
  • precision
  • REAL
  • row
  • scale
  • SERIAL
  • SERIAL8
  • SET
  • SMALLFLOAT
  • SMALLINT
  • smart large object
  • SQL_BIGINT
  • SQL_BIT
  • SQL_CHAR
  • SQL_DATE
  • SQL_DECIMAL
  • SQL_DOUBLE
  • SQL_IFMX_UDT_BLOB
  • SQL_IFMX_UDT_CLOB
  • SQL_INFX_UDT_FIXED
  • SQL_INFX_UDT_VARYING
  • SQL_INTEGER
  • SQL_LONGVARBINARY
  • SQL_LONGVARCHAR (1), (2)
  • SQL_REAL
  • SQL_SMALLINT
  • SQL_TIMESTAMP
  • SQL_VARCHAR
  • TEXT
  • VARCHAR
• SQL_DATE data type
• SQL_DECIMAL data type
• SQL_DESC_OCTET_LENGTH, and bookmarks
• SQL_DOUBLE data type
• SQL_ENABLE_INSERT_CURSOR
• SQL_IFMX_UDT_BLOB data type
• SQL_IFMX_UDT_CLOB data type
• SQL_INFX_ATTR_AUTO_FREE
• SQL_INFX_ATTR_DEFAULT_UDT_FETCH_TYPE
• SQL_INFX_ATTR_DEFERRED_PREPARE
• SQL_INFX_ATTR_ENABLE_INSERT_CURSORS
• SQL_INFX_ATTR_ENABLE_SCROLL_CURSORS
• SQL_INFX_ATTR_LO_AUTOMATIC (1), (2)
• SQL_INFX_ATTR_ODBC_TYPES_ONLY (1), (2)
• SQL_INFX_ATTR_OPTIMIZE_AUTOCOMMIT
• SQL_INFX_ATTR_OPTMSG
• SQL_INFX_ATTR_OPTOFC
• SQL_INFX_ATTR_REPORT_KEYSET_CURSORS
• SQL_INFX_UDT_FIXED data type
• SQL_INFX_UDT_VARYING data type
• SQL_INTEGER data type
• SQL_LONGVARBINARY data type
• SQL_LONGVARCHAR data type (1), (2)
• SQL_REAL data type
• SQL_SMALLINT data type
• SQL statements
  • native
• SQL_TIMESTAMP data type
• SQL_VARCHAR data type
• SQLAllocConnect
  • See also Connection handles.
  • function description
• SQLAllocEnv
  • See also Environment handles.
  • function description
• SQLAllocStmt
  • See also Statement handles.
  • function description
• SQLBindCol
  • function description
• SQLBindParameter
  • function description
• SQLBrowseConnect
  • function description
• SQLBulkOperations
  • bookmarks
  • function description
• SQLCancel, function description
• SQLColAttributes, function description
• SQLColumnPrivileges, function description
• SQLColumns, function description
• SQLConnect, function description
• SQLDataSources, function description
• SQLDescribeCol, function description
• SQLDescribeParam
• SQLDisconnect, function description
• SQLDriverConnect, function description
• SQLDrivers, function description
• SQLError
  • See also Errors; SQLSTATE.
  • function description
• SQLExecDirect, function description
• SQLExecute, function description
• SQLExtendedFetch
  • bookmarks
  • function description
• SQLFetch, function description
• SQLFetchScroll, bookmarks
• SQLForeignKeys, function description
• SQLFreeConnect
  • See also Connection handles.
  • function description
• SQLFreeEnv
  • See also Environment handles.
  • function description
• SQLFreeStmt
  • See also Statement handles.
  • function description
• SQLGetConnectOption, function description
• SQLGetCursorName, function description
• SQLGetData, function description
• SQLGetFunctions, function description
• SQLGetInfo, function description
• SQLGetStmtOption, function description
• SQLGetTypeInfo
  • function description
  • supported data types
• sqlhosts file
• SQLMoreResults, function description
• SQLNativeSql, function description
• SQLNumParams, function description
• SQLNumResultCols, function description
• SQLParamData
  • function description
  • SQLPutData
• SQLParamOptions
  • function description
  • multiple parameter values
• SQLPrepare
  • deferring execution
  • function description
• SQLPrimaryKeys, function description
• SQLProcedureColumns, function description
• SQLProcedures, function description
• SQLPutData
  • function description
  • SQLParamData
• SQLRowCount, function description
• SQLSetConnectOption
  • See also Connection options.
  • function description
• SQLSetCursorName, function description
• SQLSetPos
  • column binding
  • error messages
  • LockType argument
    • SQL_CA1_LOCK_NO_CHANGE
  • operation argument
    • SQL_CA1_POS_DELETE
    • SQL_CA1_POS_POSITION
    • SQL_CA1_POS_REFRESH
    • SQL_CA1_POS_UPDATE
  • positioned UPDATE and DELETE statements
  • scroll cursors (1), (2)
  • SQLGetData (1), (2)
  • SQLParamData
  • SQLRowCount
• SQLSetStmtOption
  • function description
• SQLSpecialColumns, function description
• SQLSTATE
  • naming conventions
  • values
    • See also Error messages.
  • values.
    • See also specific function descriptions.
• SQLStatistics
  • function description
• SQLTablePrivileges, function description
• SQLTables, function description
• SQLTransact, function description
• SqlType
• Statement handles
  • defined
  • HSTMT variable type
  • SQLAllocStmt
  • SQLFreeStmt
• Status array, errors
• Status information.
  • See also Errors.
• Storage characteristics
  • create-time flags
  • disk-storage information
  • inheritance hierarchy
• String data.
  • See also Character data.
• SWORD typedef
• Syntax diagrams
  • conventions for
  • keywords in
  • reading in a screen reader
  • variables in
• Syntax segment
• syscolattribs
• System requirements
  • database
  • software

• Table
  • columns.
    • See also Columns.
  • indexes.
    • See also SQLStatistics.
  • rows.
    • See also Rows.
• Termination byte, null.
  • See also Null-termination byte.
• TEXT data type
• Threads, multiple
  • with environment handles
• Time-stamp data
  • converting to C
  • converting to SQL
• TIMESTAMP_STRUCT typedef
• TOC Notes
• Tracing values in ODBC
• Transactions
  • concurrency
  • incomplete
• Transferring binary data
• Translation
  • library
  • options
  • shared library
    • error (1), (2), (3), (4), (5)
• TRANSLATION_OPTION environment variable
• TRANSLATIONDLL environment variable (1), (2)
• Truncating data (1), (2)
  • See also Character data., Binary data; Character data.
  • output buffers
  • SQLBindCol
• Typedefs
  • DATE_STRUCT
  • SCHAR
  • SDOUBLE
  • SDWORD
  • SFLOAT
  • SWORD
  • TIMESTAMP_STRUCT
  • UCHAR
  • UDWORD
  • UWORD
• Typographical conventions

• UCHAR typedef
• UDT fetch type
• UDWORD typedef
• Unicode
• Unnamed rows
• UPDATE statements
  • See also SQLSetPos.
  • affected rows (1), (2)
  • bulk
• User ID
• Users, types
• UWORD typedef

• VARCHAR data type
• Variable, binding
  • SQL_INFX_UDT_FIXED
• Variables, binding
  • estbytes input argument
  • SQL_INFX_UDT_VARYING
• Variables, in syntax diagrams
• Visual Basic client-side cursors
• Visual disabilities
  • reading syntax diagrams
• VMBCHARLENEXACT environment variable

• Window handles.
  • See also SQLDriverConnect.

• XA (1), (2), (3)