Index

• .java file, retaining

• 5.x database servers

• absolute() method (1), (2), (3)
• Accessibility
  • dotted decimal format of syntax diagrams
  • syntax diagrams, reading in a screen reader
• Accessing a database remotely
• activateHDRPool_Primary() method
• activateHDRPool_Secondary() method
• addBatch() method
• addProp() method
• afterLast() method
• Alignment values
• Anonymous search of sqlhosts information
• APPLET tag
• Applets
  • and database access
  • unsigned, features unavailable for
  • using IBM Informix JDBC Driver in (1), (2)
• ARCHIVE attribute of APPLET tag
• Array class
• ArrayList class
• Arrays (1), (2)
• Autocommit
• autofree.java example program (1), (2)
• Automatically freeing the cursor (1), (2)

• Batch updates to the database
• BatchUpdate.java example program (1), (2)
• BatchUpdateException interface
• beforeFirst() method (1), (2)
• BEGIN WORK statement
• BIG_FET_BUF_SIZE environment variable (1), (2)
• Binary qualifiers for INTERVAL data types
• BLOB and CLOB data types, accessing
• BLOB and CLOB example programs
• BLOB data type
  • caching (1), (2), (3)
  • definition of
  • examples of
    • creation
    • data retrieval
  • extensions for
  • format of
• Boldface type
• BOOLEAN data type
• Browsers
• Bulk inserts
• BulkInsert.java example program
• BYTE and TEXT example programs
• Byte array, converting to hexadecimal
• BYTE data type
  • caching
  • examples for
    • data inserts and updates
    • data retrieval
  • extensions for
• ByteType.java example program (1), (2), (3)

• Caching large objects
• Caching type information (1), (2)
• CallableStatement interface (1), (2), (3), (4)
• CallOut1.java example program
• CallOut2.java example program
• CallOut3.java example program
• CallOut4.java example program
• cancel() method
• Catalogs
  • IBM Informix JDBC Driver interpretation
  • systables (1), (2), (3)
• charattrUDT.java example program
• Class name
• Classes
  • Array
  • ArrayList
  • extensibleObject
  • HashSet (1), (2), (3)
  • helper
  • IfmxStatement
  • IfxBblob
  • IfxCblob
  • IfxConnectionEventListener
  • IfxConnectionPoolDataSource (1), (2)
  • IfxCoreDataSource
  • IfxDataSource (1), (2)
  • IfxDriver
  • IfxJDBCProxy
  • IfxLobDescriptor
  • IfxLocator
  • IfxPooledConnection
  • IfxTypes (1), (2)
  • IfxUDTManager
  • IfxUDTMetaData
  • IfxXADataSource
  • Interval
  • IntervalDF
  • IntervalYM
  • Java.Socket
  • Locale
  • Message
  • Properties
  • ResultSet (1), (2)
  • SessionMgr
  • SQLException (1), (2), (3), (4), (5)
  • SqlhDelete
  • SqlhUpload
  • TimeoutMgr
  • TreeSet
  • UDRManager
  • UDRMetaData
  • Version
• Classes implemented
  • beyond Java specification
  • extending Java specification
  • Java interfaces
• ClassGenerator utility (1), (2), (3)
• CLASSPATH environment variable (1), (2), (3)
• Cleaning connections
• CLIENT_LOCALE environment variable (1), (2)
• Clob::setAsciiStream(long position, InputStream fin, int length) method
• CLOB data type
  • caching (1), (2), (3)
  • code set conversion
  • definition of
  • examples of
    • creation
    • data retrieval
  • extensions for
  • format of
• close() method (1), (2), (3), (4), (5), (6), (7)
• Code, sample, conventions for
• Code sets
  • conversion of (1), (2)
  • converting TEXT data types
  • synchronizing with locales
  • table of
  • user-defined
• codeset conversion
• Collection data types
  • examples of
    • using the array interface
    • using the collection interface
  • extensions for
  • in named and unnamed rows
• Collection interface (1), (2), (3)
• com.informix.jdbc.Message class
• Command-line conventions
  • how to read
  • sample diagram
• commit() method
• COMMIT WORK statement
• Compliance
  • with industry standards
• Concurrency and multiple threads
• connect() method
• Connection.close() method
• Connection interface (1), (2)
• Connection pool
  • cleaning connections
  • demo program
  • example programs
  • properties for
  • Sun JDBC 3.0 properties
  • tuning parameters
  • using
  • with HDR
• Connection Pool Manager
  • properties
• Connection pooling (1), (2), (3), (4)
• Connection properties
  • DATABASE
  • IFXHOST
  • INFORMIXSERVER
  • PASSWORD (1), (2)
  • PORTNO
  • USER (1), (2)
• ConnectionEventListener interface
• ConnectionPoolDataSource
• ConnectionPoolDataSource interface
• ConnectionPoolDataSource object
• Connections
  • cleaning
  • creating using a DataSource object
  • creating using DriverManager. getConnection()
  • to a database with non-ASCII characters
• Console mode
• Constructors
  • IfxBblob()
  • IfxCblob()
  • IfxLobDescriptor()
  • IfxLocator()
  • IntervalDF()
  • IntervalYM()
• Contact information
• Conventions
  • command-line
  • documentation
  • sample-code
  • syntax diagrams
  • syntax notation
  • typographical
• Converting
  • IfxLocator to hexadecimal
• CORBA
• Create opaque type from existing code
• createJar() method
• createTypes.java example program
• createUDRs() method
• createUDT() method
• createUDTClass() method (1), (2), (3)
• Creating opaque type without preexisting class
• Creating smart large objects
• CSM environment variable
• current() method
• Cursors
  • automatically freeing (1), (2), (3)
  • hold
  • scroll

• Data integrity
• Data types
  • BLOB
  • BOOLEAN
  • BYTE (1), (2)
  • CLOB
  • collection
  • DataBlade API
  • distinct
  • INTERVAL
  • LVARCHAR (1), (2)
  • mapping
    • for CallableStatement parameters
    • opaque data types
  • named row
  • opaque
    • and transactions
  • SERIAL
  • SERIAL8
  • TEXT (1), (2)
  • unnamed row
• DATABASE environment variable (1), (2)
• database local codeset
• Database server name
  • setting in database URLs
  • setting in DataSource objects
• DatabaseMetaData interface (1), (2)
• DatabaseMetaData methods
• Databases
  • batch updates of
  • names of, setting
    • in database URLs
    • in DataSource objects
  • querying
  • remote access options
  • specifying the locale of
  • URL (1), (2)
  • with non-ASCII characters
• DataBlade API data types
• DataSource interface
  • example of
  • extensions of
  • Informix classes supporting
  • standard properties (1), (2)
• Dates
  • DBDATE formats of
  • formatting directives for
  • four-digit year expansion
  • GL_DATE formats of
  • inserting values (1), (2)
  • native SQL formats of (1), (2)
  • nonnative SQL formats of (1), (2)
  • precedence rules for end-user formats
  • represented by strings
  • retrieving values (1), (2)
  • string-to-date conversion
  • support for end-user formats
• DB_LOCALE environment variable (1), (2)
• DBANSIWARN environment variable
• DBCENTURY environment variable (1), (2)
• DBCENTURYSelect.java example program (1), (2)
• DBCENTURYSelect2.java example program (1), (2)
• DBCENTURYSelect3.java example program (1), (2)
• DBCENTURYSelect4.java example program (1), (2)
• DBCENTURYSelect5.java example program (1), (2)
• DBConnection.java example program (1), (2)
• DBDATE environment variable (1), (2), (3)
• DBDATESelect.java example program
• DBMetaData.java example program
• DBSPACETEMP environment variable
• DBTEMP environment variable
• DBUPSPACE environment variable
• Deallocating resources
• Debugging
• Default locale
• deleteRow() method (1), (2)
• deletesAreDetected() method
• DELIMIDENT environment variable
• Deploy parameter
• Deployment descriptor
• Describe input parameter
• DESCRIBE INPUT statement
• Directives, formatting, for dates
• Disabilities, visual
  • reading syntax diagrams
• dispValue() method
• distinct_d1.java example program
• distinct_d2.java example program
• Distinct data types
  • caching type information (1), (2)
  • examples for
    • inserting data
    • retrieving data
  • extensions for
  • unsupported methods for
• Distributed transactions (1), (2), (3), (4)
• Documentation, types of
  • machine notes
  • online manuals
  • printed manuals
• Documentation conventions
• Documentation Notes
• Documentation set of all manuals
• DOM (Document Object Model)
• Dotted decimal format of syntax diagrams
• Driver interface
• Driver restrictions, limitations
• DriverManager interface (1), (2), (3), (4)
• Dynamic SQL

• en_us.8859-1 locale
• ENABLE_CACHE_TYPE environment variable (1), (2), (3)
• ENABLE_HDRSWITCH environment variable (1), (2)
• End-user formats for dates
  • precedence rules for
  • support for
• Environment variables
  • BIG_FET_BUF_SIZE
  • CLASSPATH (1), (2), (3)
  • CLIENT_LOCALE (1), (2)
  • CSM
  • DATABASE (1), (2)
  • DB_LOCALE (1), (2)
  • DBANSIWARN
  • DBCENTURY (1), (2)
  • DBDATE (1), (2), (3)
  • DBSPACETEMP
  • DBTEMP
  • DBUPSPACE
  • DELIMIDENT
  • ENABLE_CACHE_TYPE (1), (2), (3)
  • ENABLE_HDRSWITCH (1), (2)
  • FET_BUF_SIZE (1), (2), (3)
  • GL_DATE (1), (2), (3)
  • IFMX_CPM_AGELIMIT
  • IFMX_CPM_ENABLE_SWITCH_HDRPOOL
  • IFMX_CPM_INIT_POOLSIZE
  • IFMX_CPM_MAX_CONNECTIONS
  • IFMX_CPM_MAX_POOLSIZE
  • IFMX_CPM_MIN_AGELIMIT
  • IFMX_CPM_MIN_POOLSIZE
  • IFMX_CPM_SERVICE_INTERVAL
  • IFX_AUTOFREE (1), (2), (3)
  • IFX_BATCHUPDATE_PER_SPEC (1), (2)
  • IFX_CODESETLOB (1), (2), (3)
  • IFX_DIRECTIVES
  • IFX_EXTDIRECTIVES
  • IFX_GET_SMFLOAT_AS_FLOAT
  • IFX_PADVARCHAR
  • IFX_SET_FLOAT_AS_SMFLOAT
  • IFX_USEPUT (1), (2)
  • IFX_XASPEC
  • IFXHOST (1), (2), (3)
  • IFXHOST_SECONDARY (1), (2)
  • INFORMIXCONRETRY
  • INFORMIXCONTIME
  • INFORMIXOPCACHE
  • INFORMIXSERVER (1), (2), (3), (4)
  • INFORMIXSERVER_SECONDARY (1), (2)
  • INFORMIXSTACKSIZE
  • JDBCTEMP
  • LOBCACHE (1), (2), (3), (4)
  • NEWCODESET (1), (2)
  • NEWLOCALE (1), (2)
  • NEWNLSMAP
  • NODEFDAC
  • OPT_GOAL
  • OPTCOMPIND
  • OPTOFC (1), (2), (3)
  • PATH
  • PDQPRIORITY
  • PLCONFIG
  • PLOAD_LO_PATH
  • PORTNO (1), (2)
  • PORTNO_SECONDARY (1), (2)
  • PROXY
  • PSORT_DBTEMP
  • PSORT_NPROCS
  • SECURITY
  • specifying (1), (2)
  • SQLH_TYPE
  • STMT_CACHE
  • supported
  • USEV5SERVER
• equals() method (1), (2)
• Error messages
• Error Messages
  • localization of
  • RSAM
  • SQLCODE
  • standard Informix
• ErrorHandling.java example program (1), (2)
• Errors
  • handling
  • retrieving message text
  • retrieving syntax error offset
  • SQLException class, using
• Escape syntax
• Example programs
  • connection pool
  • HDR
  • proxy server
  • XML documents
• Examples
  • autofree.java (1), (2)
  • BatchUpdate.java (1), (2)
  • BLOB and CLOB
  • BLOB and CLOB data types
    • creation
    • data retrieval
  • BulkInsert.java
  • BYTE and TEXT
  • BYTE and TEXT data types (1), (2)
  • ByteType.java (1), (2), (3)
  • CallOut1.java
  • CallOut2.java
  • CallOut3.java
  • CallOut4.java
  • charattrUDT.java
  • collection data types
    • using the array interface
    • using the collection interface
  • createTypes.java
  • DataSource
  • DBCENTURYSelect.java (1), (2)
  • DBCENTURYSelect2.java (1), (2)
  • DBCENTURYSelect3.java (1), (2)
  • DBCENTURYSelect4.java (1), (2)
  • DBCENTURYSelect5.java (1), (2)
  • DBConnection.java (1), (2)
  • DBDATESelect.java
  • DBMetaData.java
  • distinct_d1.java
  • distinct_d2.java
  • distinct data types
    • inserting data
    • retrieving data
  • ErrorHandling.java (1), (2)
  • GenericStruct.java
  • GLDATESelect.java
  • Intervaldemo.java (1), (2)
  • largebinUDT.java
  • list1.java
  • list2.java
  • LOCALESelect.java
  • locmsg.java (1), (2)
  • manualUDT.java
  • MultiRowCall.java
  • myMoney.java
  • named and unnamed rows
    • creating a Struct class for
    • using the SQLData interface for a named row
    • using the Struct interface
  • named row
  • opaque data types
    • defining a class for
    • large objects
    • retrieving data
  • OptimizedSelect.java
  • optofc.java (1), (2), (3)
  • OUT parameters
  • PropertyConnection.java
  • row3.java
  • RSMetaData.java
  • ScrollCursor.java (1), (2)
  • Serial.java
  • SimpleCall.java
  • SimpleConnection.java
  • SimpleSelect.java
  • smart large object (1), (2)
  • TextConv.java
  • TextType.java (1), (2), (3)
  • UDR Manager
  • udt_d1.java
  • udt_d2.java
  • udt_d3.java
  • UDT Manager
  • UpdateCursor1.java (1), (2)
  • UpdateCursor2.java (1), (2)
  • UpdateCursor3.java (1), (2)
  • user-defined routines
  • XML documents
• execute() method (1), (2), (3), (4), (5)
• executeBatch() method
• executeQuery() method (1), (2), (3), (4)
• executeUpdate() method (1), (2), (3)
• executeXXX() method
• extensibleObject class

• FET_BUF_SIZE environment variable (1), (2), (3), (4)
• File interface
• FileInputStream interface
• Files
  • SessionMgr.class
• FilesTimeoutMgr.class
• first() method (1), (2)
• Fixed and Known Defects File
• Formatting directives for dates
• forName() method
• Freeing cursors
• fromHexString() method
• fromString() method (1), (2)

• GenericStruct.java example program
• getAlignment() method
• getArray() method (1), (2), (3)
• getAsciiStream() method (1), (2), (3)
• getAttributes() method (1), (2)
• getAutoAlignment() method
• getAutoFree() method (1), (2)
• getBinaryStream() method (1), (2), (3), (4)
• getBlob() method (1), (2), (3)
• getBytes() method (1), (2), (3)
• getCatalogName() method
• getCatalogs() method
• getClassName() method
• getClob() method (1), (2), (3)
• getConnection() method (1), (2), (3), (4), (5)
• getCurrentPosition() method
• getDatabaseName() method
• getDataSourceName() method
• getDate() method (1), (2), (3), (4)
• getDescription() method
• getDriverMajorVersion() method
• getDriverMinorVersion() method
• getDsProperties() method
• getEndCode() method
• getErrorCode() method
• getFetchSize() method
• getFieldCount() method
• getFieldLength() method
• getFieldName() method
• getFieldName method
• getFieldTypeName() method
• getHDRtype() method
• getIfxCLIENT_LOCALE() method
• getIfxCPMInitPoolSize() method
• getIfxCPMMaxAgeLimit() method
• getIfxCPMMaxConnections() method
• getIfxCPMMaxPoolSize() method
• getIfxCPMMinAgeLimit() method
• getIfxCPMMinPoolSize() method
• getIfxCPMServiceInterval() method
• getIfxCPMSwitchHDRPool() method
• getIfxCSM() method
• getIfxDB_LOCALE() method
• getIfxDBCENTURY() method
• getIfxDBDATE() method
• getIfxDBSPACETEMP() method
• getIfxDBTEMP() method
• getIfxDBUPSPACE() method
• getIfxFET_BUF_SIZE() method
• getIfxGL_DATE() method
• getIfxIFX_CODESETLOB() method
• getIfxIFX_DIRECTIVES() method
• getIfxIFX_EXTDIRECTIVES() method
• getIfxIFX_IFX_GET_SMFLOAT_AS_FLOAT() method
• getIfxIFX_ISOLATION_LEVEL() method
• getIfxIFX_LOCK_MODE_WAIT()
• getIfxIFX_LOCK_MODE_WAIT() method
• getIfxIFX_SET_FLOAT_AS_SMFLOAT() method
• getIfxIFX_XASPEC() method
• getIfxIFXHOST() method
• getIfxIFXHOST_SECONDARY() method
• getIfxINFORMIXCONRETRY() method
• getIfxINFORMIXCONTIME() method
• getIfxINFORMIXOPCACHE() method
• getIfxINFORMIXSERVER_SECONDARY() method
• getIfxINFORMIXSTACKSIZE() method
• getIfxJDBCTEMP() method
• getIfxLDAP_IFXBASE() method
• getIfxLDAP_PASSWD() method
• getIfxLDAP_URL() method
• getIfxLDAP_USER() method
• getIfxLOBCACHE() method
• getIfxNEWCODESET() method
• getIfxNEWLOCALE() method
• getIfxNEWNLSMAP() method
• getIfxNODEFDAC() method
• getIfxOPT_GOAL() method
• getIfxOPTCOMPIND() method
• getIfxOPTOFC() method
• getIfxPATH() method
• getIfxPDQPRIORITY() method
• getIfxPLCONFIG() method
• getIfxPLOAD_LO_PATH() method
• getIfxPORTNO_SECONDARY() method
• getIfxPROTOCOLTRACE() method
• getIfxPROTOCOLTRACEFILE() method
• getIfxPROXY() method
• getIfxPSORT_DBTEMP() method
• getIfxPSORT_NPROCS() method
• getIfxSECURITY() method
• getIfxSQLH_FILE() method
• getIfxSQLH_TYPE() method
• getIfxSTMT_CACHE() method
• getIfxTRACE() method
• getIfxTRACEFILE() method
• getIfxTypeName() method
• getInputSource() method
• getJarFileSQLName() method
• getJDBCVersion() method
• getLength() method (1), (2)
• getLocator() method (1), (2)
• getMajorVersion() method
• getMessage() method
• getMetaData() method
• getMinorVersion() method
• getMonths() method
• getNanoSeconds() method
• getNextException() method
• getObject() method (1), (2), (3), (4), (5)
• getParameterAlignment method
• getParameterExtendedId method
• getParameterExtendedName method
• getParameterExtendedOwnerName method
• getParameterLength method
• getParameterMetaData() method (1), (2)
• getParameterSourceType method
• getPassword() method
• getPortNumber() method
• getProcedureColumns() method
• getProp() method
• getQualifier() method
• getRef() method (1), (2), (3)
• getResultSet() method (1), (2)
• getScale() method
• getSchemaName() method
• getSchemas() method
• getSeconds() method
• getSerial() method
• getSerial8() method
• getServerName() method
• getSQLName() method
• getSQLState() method
• getSQLStatementOffset() method
• getSQLTypeName() method (1), (2), (3), (4), (5), (6), (7)
• getStartCode() method
• getString() method (1), (2), (3), (4), (5)
• getTableName() method
• getText() method
• getTimestamp() method (1), (2), (3), (4)
• getTypeMap() method (1), (2), (3)
• getUDR() method
• getUDRSQLname() method
• getUnicodeStream() method (1), (2)
• getUpdateCount() method (1), (2)
• getUpdateCounts() method
• getUser() method
• getWarnings() method
• getXXX() method (1), (2), (3), (4), (5)
• GL_DATE environment variable (1), (2), (3)
• GLDATESelect.java example program
• Global Language Support (GLS) (1), (2)
• Graphical mode (1), (2)
• greaterThan() method (1), (2)
• group option, of sqlhosts file

• HashSet class (1), (2), (3)
• hasOutParameter() method
• Help
• Hexadecimal format, converting between
• Hexadecimal string format
• High-Availability Data Replication
  • checking read-only status
  • demo for
  • environment variables for
  • example programs
  • IFMX_CPM_ENABLE_SWITCH_HDRPOOL
  • retrying connections
  • specifying secondary servers
  • using
  • with connection pooling
• Hold cursors
• Host names, setting
  • in database URLs
  • in DataSource objects
• HTTP proxy (1), (2)

• IBM Informix JDBC Driver
  • connection pools, using with
• IBM xml4j parser
• IFMX_CPM_AGELIMIT environment variable
• IFMX_CPM_ENABLE_SWITCH_HDRPOOL environment variable
• IFMX_CPM_INIT_POOLSIZE environment variable
• IFMX_CPM_MAX_CONNECTIONS environment variable
• IFMX_CPM_MAX_POOLSIZE environment variable
• IFMX_CPM_MIN_AGELIMIT environment variable
• IFMX_CPM_MIN_POOLSIZE environment variable
• IFMX_CPM_SERVICE_INTERVAL environment variable
• IfmxCallableStatement interface
• IfmxStatement class
• IfmxUdtSQLInput interface (1), (2)
• IfmxUdtSQLOutput interface (1), (2)
• IFX_AUTOFREE environment variable (1), (2), (3)
• IFX_BATCHUPDATE_PER_SPEC environment variable (1), (2)
• IFX_CODESETLOB
• IFX_CODESETLOB environment variable (1), (2), (3), (4)
• IFX_DIRECTIVES environment variable
• IFX_EXTDIRECTIVES environment variable
• IFX_GET_SMFLOAT_AS_FLOAT environment variable
• IFX_ISOLATION_LEVEL (1), (2)
• IFX_ISOLATION_LEVEL connection property
• IFX_LOCK_MODE_WAIT (1), (2)
• IFX_LOCK_MODE_WAIT connection property
• IFX_PADVARCHAR environment variable
• IFX_SET_FLOAT_AS_SMFLOAT environment variable
• IFX_USEPUT environment variable (1), (2)
• IFX_XASPEC environment variable
• IFX_XASTDCOMPLIANCE_XAEND() method
• IFX_XASTDCOMPLIANCE_XAEND(int value) method
• IfxBblob() constructor
• IfxBblob class
• IfxCblob() constructor
• IfxCblob::setAsciiStream(long) method
• IfxCblob class
• IfxCblob interface
• IfxConnectionEventListener class
• IfxConnectionPoolDataSource class (1), (2)
• IfxCoreDataSource class
• IfxDataSource class (1), (2)
• IfxDriver class
• IFXHOST environment variable (1), (2), (3)
• IFXHOST_SECONDARY environment variable (1), (2)
• ifxjdbc.jar
• ifxjdbc.jar file (1), (2)
• IfxJDBCProxy class
• IfxJDBCProxy.class file (1), (2)
• ifxjdbcx.jar
• ifxjdbcx.jar file
• ifxlang.jar file (1), (2)
• IfxLobDescriptor() constructor
• IfxLobDescriptor class
• IfxLocator() constructor
• IfxLocator() method
• IfxLocator class
• IfxLocator object
  • converting to hex format
  • converting to hexadecimal
• IfxLoClose() method
• IfxLoCreate() method (1), (2), (3), (4)
• IfxLoOpen() method (1), (2), (3), (4)
• IfxLoRead() method (1), (2), (3), (4), (5)
• IfxLoRelease() method (1), (2), (3)
• IfxLoSeek() method
• IfxLoSize() method
• IfxLoTell() method
• IfxLoTruncate() method
• IfxLoWrite() method (1), (2)
• IfxPooledConnection class
• IfxRegisterOutParameter() method (1), (2), (3), (4)
• IfxSetNull() method (1), (2)
• IfxSetObject() method (1), (2)
• ifxsqlj.jar file
• ifxtools.jar file (1), (2), (3), (4)
• IfxTypes class (1), (2)
• IfxXADataSource class
• Industry standards, compliance with
• Informix base distinguished name
• Informix Dynamic Server documentation set
• Informix extensions
  • to Clob interface
• INFORMIX-SE 5.x database servers
• INFORMIXCONRETRY environment variable
• INFORMIXCONTIME environment variable
• INFORMIXOPCACHE environment variable
• INFORMIXSERVER environment variable (1), (2), (3), (4)
• INFORMIXSERVER_SECONDARY environment variable (1), (2)
• INFORMIXSTACKSIZE environment variable
• initialPoolSize
• INOUT parameters
• InputStream interface
• InputStreamReader() method (1), (2), (3)
• InputStreamtoDOM() method
• Inserting DATE values (1), (2)
• Inserting smart large objects
• Inserting XML data
• insertRow() method (1), (2)
• Inserts, bulk
• insertsAreDetected() method
• install.txt file
• Installation Guides
• Installing
  • console mode
  • graphical mode
  • silent mode
• Interfaces
  • BatchUpdateException
  • Blob
  • CallableStatement (1), (2), (3), (4)
  • Clob
  • Collection (1), (2), (3)
  • Connection (1), (2)
  • ConnectionEventListener
  • ConnectionPoolDataSource
  • DatabaseMetaData (1), (2)
  • DataSource
    • Informix classes supporting
    • standard properties
  • Driver
  • DriverManager (1), (2), (3), (4)
  • File
  • FileInputStream
  • IfmxCallableStatement
  • IfmxUdtSQLInput
  • IfmxUdtSQLOutput
  • IfxCblob
  • InputStream
  • java.sql.Blob
  • java.sql.PreparedStatement
  • List
  • PooledConnection
  • PreparedStatement (1), (2), (3), (4), (5)
  • ResultSet (1), (2), (3), (4), (5)
  • ResultSetMetaData
  • Set
  • SQLData (1), (2), (3), (4), (5)
  • SQLInput
  • Statement (1), (2), (3), (4)
  • Struct (1), (2)
  • Types (1), (2)
  • XAConnection
  • XADataSource
• Internationalization (1), (2)
• Interval class
• INTERVAL data type
  • binary qualifiers for
  • extensions for
  • in named and unnamed rows
• Intervaldemo.java example program (1), (2)
• IntervalDF() constructor
• IntervalDF class
• IntervalYM() constructor
• IntervalYM class
• IP address, setting
  • in database URLs
  • in DataSource objects
• IPv6 aware
• isDefinitelyWriteable() method
• isHDREnabled() method
• isIfxDBANSIWARN() method
• isIfxDELIMIDENT() method
• isIfxENABLE_CACHE_TYPE() method (1), (2)
• isIfxIFX_AUTOFREE() method
• isIfxIFX_USEPUT() method
• isIfxUSEV5SERVER() method
• ISO 8859-1 code set
• isReadOnly() method (1), (2), (3)
• isWriteable() method

• JAR file, location on server
• JAR files
  • for JNDI
  • for LDAP SPI
  • ifxjdbc.jar (1), (2)
  • ifxjdbcx.jar
  • ifxlang.jar (1), (2)
  • ifxsqlj.jar
  • ifxtools.jar (1), (2)
• jar utility
• java.io file
• Java naming and directory interface (JNDI)
  • and the sqlhosts file
  • JAR files for
• Java.Socket class
• java.sql.Blob interface
• java.sql.Clob interface
  • methods
• java.sql.ParameterMetaData class
• java.sql.PreparedStatement
  • methods from
• java.sql.PreparedStatement interface
• java.text file
• java.util file
• Java virtual machine (JVM)
• Javadoc pages, for Informix extensions
• JavaSoft (1), (2)
• JDBC 3.0
  • methods
• JDBC 3.0 specification
  • java.sql.Blob interface
  • java.sql.Clob interface
• JDBC 3.0 Specification compliance
• JDBC API
• JDBC driver, general (1), (2)
• jdbcdoc.htm file
• jdbcrel.htm file
• JDBCTEMP environment variable

• keepJavaFile() method
• Keywords
  • in syntax diagrams

• largebinUDT.java example program
• last() method
• LDAP server
  • and HTTP proxy
  • updating with sqlhosts data
• length() method
• lessThan() method (1), (2)
• Lightweight directory access protocol (LDAP) server
  • administration requirements for
  • and the sqlhosts file
  • and unsigned applets
  • JAR files for
  • loader for
  • URL syntax for
  • utilities for
  • version requirement
• Limitations, driver
• Limitations, server
• List interface
• list1.java example program
• list2.java example program
• LO handle
  • in BLOB column
  • in CLOB column
• Loading IBM Informix JDBC Driver
• LOBCACHE environment variable (1), (2), (3), (4)
• Locale class
• Locales
  • assumptions about
  • client, specifying
  • database, specifying
  • synchronizing with code sets
  • table of
  • user-defined
• LOCALESelect.java example program
• Localization
• Locator object
• Lock
  • row
• locmsg.java example program (1), (2)
• Logging install events
• LVARCHAR data type (1), (2)

• Machine notes
• manualUDT.java example program
• map.get() method
• map.put() method (1), (2)
• Mapping
  • for CallableStatement parameters
  • opaque data types
• maxIdleTime
• maxPoolSize
• maxStatements
• Message class
• Metadata, accessing database
• Methods
  • absolute() (1), (2), (3)
  • activateHDRPool_Primary()
  • activateHDRPool_Secondary()
  • addBatch()
  • addProp()
  • afterLast()
  • beforeFirst() (1), (2)
  • cancel()
  • Clob::setAsciiStream(long position, InputStream fin, int length)
  • close() (1), (2), (3), (4), (5), (6), (7)
  • commit()
  • connect()
  • createJar()
  • createUDRs()
  • createUDT()
  • createUDTClass()
  • current()
  • deleteRow()
  • deleteRow(), and scroll cursors
  • deletesAreDetected()
  • dispValue()
  • equals() (1), (2)
  • execute() (1), (2), (3), (4), (5)
  • executeBatch()
  • executeQuery() (1), (2), (3), (4)
  • executeUpdate() (1), (2), (3)
  • executeXXX()
  • first() (1), (2)
  • forName()
  • fromHexString()
  • fromString() (1), (2)
  • getAlignment()
  • getArray() (1), (2), (3)
  • getAsciiStream() (1), (2), (3)
  • getAttributes() (1), (2)
  • getAutoAlignment()
  • getAutoFree() (1), (2)
  • getBinaryStream() (1), (2), (3), (4)
  • getBlob() (1), (2), (3)
  • getBytes() (1), (2), (3)
  • getCatalogName()
  • getCatalogs()
  • getClassName()
  • getClob() (1), (2), (3)
  • getConnection() (1), (2), (3), (4), (5)
  • getCurrentPosition()
  • getDatabaseName()
  • getDataSourceName()
  • getDate() (1), (2), (3), (4)
  • getDescription()
  • getDriverMajorVersion()
  • getDriverMinorVersion()
  • getDsProperties()
  • getEndCode()
  • getErrorCode()
  • getFetchSize()
  • getFieldCount() (1), (2)
  • getFieldLength()
  • getFieldName() (1), (2)
  • getFieldType()
  • getFieldTypeName()
  • getHDRtype()
  • getIfxCLIENT_LOCALE()
  • getIfxCPMInitPoolSize()
  • getIfxCPMMaxAgeLimit()
  • getIfxCPMMaxConnections()
  • getIfxCPMMaxPoolSize()
  • getIfxCPMMinAgeLimit()
  • getIfxCPMMinPoolSize()
  • getIfxCPMServiceInterval()
  • getIfxCPMSwitchHDRPool()
  • getIfxCSM()
  • getIfxDB_LOCALE()
  • getIfxDBCENTURY()
  • getIfxDBDATE()
  • getIfxDBSPACETEMP()
  • getIfxDBTEMP()
  • getIfxDBUPSPACE()
  • getIfxFET_BUF_SIZE()
  • getIfxGL_DATE()
  • getIfxIFX_CODESETLOB()
  • getIfxIFX_DIRECTIVES()
  • getIfxIFX_EXTDIRECTIVES()
  • getIfxIFX_IFX_GET_SMFLOAT_AS_FLOAT()
  • getIfxIFX_ISOLATION_LEVEL()
  • getIfxIFX_SET_FLOAT_AS_SMFLOAT()
  • getIfxIFX_XASPEC()
  • getIfxIFXHOST()
  • getIfxIFXHOST_SECONDARY()
  • getIfxINFORMIXCONRETRY()
  • getIfxINFORMIXCONTIME()
  • getIfxINFORMIXOPCACHE()
  • getIfxINFORMIXSERVER_SECONDARY()
  • getIfxINFORMIXSTACKSIZE()
  • getIfxJDBCTEMP()
  • getIfxLDAP_IFXBASE()
  • getIfxLDAP_PASSWD()
  • getIfxLDAP_URL()
  • getIfxLDAP_USER()
  • getIfxLOBCACHE()
  • getIfxNEWCODESET()
  • getIfxNEWLOCALE()
  • getIfxNEWNLSMAP()
  • getIfxNODEFDAC()
  • getIfxOPT_GOAL()
  • getIfxOPTCOMPIND()
  • getIfxOPTOFC()
  • getIfxPATH()
  • getIfxPDQPRIORITY()
  • getIfxPLCONFIG()
  • getIfxPLOAD_LO_PATH()
  • getIfxPORTNO_SECONDARY()
  • getIfxPROTOCOLTRACE()
  • getIfxPROTOCOLTRACEFILE()
  • getIfxPROXY()
  • getIfxPSORT_DBTEMP()
  • getIfxPSORT_NPROCS()
  • getIfxSECURITY()
  • getIfxSQLH_FILE()
  • getIfxSQLH_TYPE()
  • getIfxSTMT_CACHE()
  • getIfxTRACE()
  • getIfxTRACEFILE()
  • getIfxTypeName()
  • getInputSource()
  • getJarFileSQLName()
  • getJDBCVersion()
  • getLength() (1), (2)
  • getLocator() (1), (2)
  • getMajorVersion()
  • getMessage()
  • getMetaData()
  • getMinorVersion()
  • getMonths()
  • getNanoSeconds()
  • getNextException()
  • getObject() (1), (2), (3), (4), (5)
  • getPassword()
  • getPortNumber()
  • getProcedureColumns()
  • getProp()
  • getQualifier()
  • getRef() (1), (2), (3)
  • getResultSet() (1), (2)
  • getScale()
  • getSchemaName()
  • getSchemas()
  • getSeconds()
  • getSerial()
  • getSerial8()
  • getServerName()
  • getSQLName() (1), (2)
  • getSQLState()
  • getSQLStatementOffset()
  • getSQLTypeName() (1), (2), (3), (4), (5), (6), (7)
  • getStartCode()
  • getString() (1), (2), (3), (4), (5)
  • getTableName()
  • getText()
  • getTimestamp() (1), (2), (3), (4)
  • getTypeMap() (1), (2), (3)
  • getUDR()
  • getUDRSQLname()
  • getUnicodeStream() (1), (2)
  • getUpdateCount() (1), (2)
  • getUpdateCounts()
  • getUser()
  • getWarnings()
  • getXXX() (1), (2), (3), (4), (5)
  • greaterThan() (1), (2)
  • hasOutParameter()
  • IFX_XASTDCOMPLIANCE_XAEND()
  • IFX_XASTDCOMPLIANCE_XAEND(int value)
  • IfxCblob::setAsciiStream(long)
  • IfxLocator()
  • IfxLoClose()
  • IfxLoCreate() (1), (2), (3), (4)
  • IfxLoOpen() (1), (2), (3), (4)
  • IfxLoRead() (1), (2), (3), (4), (5)
  • IfxLoRelease() (1), (2), (3)
  • IfxLoSeek()
  • IfxLoSize()
  • IfxLoTell()
  • IfxLoTruncate()
  • IfxLoWrite() (1), (2)
  • IfxRegisterOutParameter() (1), (2), (3), (4)
  • IfxSetNull() (1), (2)
  • IfxSetObject() (1), (2)
  • InputStreamReader() (1), (2), (3)
  • InputStreamtoDOM()
  • insertRow() (1), (2)
  • insertsAreDetected()
  • isDefinitelyWriteable()
  • isHDREnabled()
  • isIfxDBANSIWARN()
  • isIfxDELIMIDENT()
  • isIfxENABLE_CACHE_TYPE() (1), (2)
  • isIfxIFX_AUTOFREE()
  • isIfxIFX_USEPUT()
  • isIfxUSEV5SERVER()
  • isReadOnly() (1), (2), (3)
  • isWriteable()
  • keepJavaFile()
  • last()
  • length()
  • lessThan() (1), (2)
  • map.get()
  • map.put() (1), (2)
  • moveToCurrentRow()
  • moveToInsertRow()
  • next() (1), (2), (3), (4)
  • othersDeletesAreVisible()
  • othersInsertsAreVisible()
  • othersUpdatesAreVisible()
  • OutputStreamWriter() (1), (2), (3)
  • ownDeletesAreVisible()
  • ownInsertsAreVisible()
  • ownUpdatesAreVisible()
  • prepareStatement()
  • previous()
  • put() (1), (2)
  • read()
  • readArray()
  • readAsciiStream()
  • readBinaryStream()
  • readByte()
  • readBytes() (1), (2)
  • readCharacterStream() (1), (2), (3)
  • readObject() (1), (2), (3)
  • readProperties()
  • readRef() (1), (2), (3)
  • readSQL() (1), (2), (3), (4)
  • readString() (1), (2)
  • refreshRow()
  • registerDriver()
  • registerOutParameter() (1), (2), (3)
  • relative()
  • removeJar() (1), (2)
  • removeProperty()
  • removeUDR() (1), (2)
  • rowDeleted()
  • rowInserted()
  • rowUpdated()
  • scrubConnection()
  • set() (1), (2)
  • setAlignment()
  • setArray() (1), (2)
  • setAsciiStream() (1), (2), (3), (4)
  • setAutoAlignment()
  • setAutoCommit()
  • setAutoFree() (1), (2)
  • setBigDecimal() (1), (2), (3)
  • setBinaryStream() (1), (2), (3), (4)
  • setBlob()
  • setBoolean()
  • setByte()
  • setBytes()
  • setCatalog()
  • setCharacterStream()
  • setClassName()
  • setClob()
  • setCurrentPosition()
  • setDatabaseName()
  • setDataSourceName()
  • setDate()
  • setDescription()
  • setDouble()
  • setExplicitCast()
  • setFetchDirection() (1), (2)
  • setFetchSize() (1), (2)
  • setFieldCount()
  • setFieldLength()
  • setFieldType()
  • setFieldTypeName()
  • setFloat()
  • setIfxCLIENT_LOCALE()
  • setIfxCPMInitPoolSize()
  • setIfxCPMMaxAgeLimit()
  • setIfxCPMMaxConnections()
  • setIfxCPMMaxPoolSize()
  • setIfxCPMMinAgeLimit()
  • setIfxCPMMinPoolSize()
  • setIfxCPMServiceInterval()
  • setIfxCPMSwitchHDRPool()
  • setIfxCSM (String csm)
  • setIfxDB_LOCALE()
  • setIfxDBANSIWARN()
  • setIfxDBCENTURY()
  • setIfxDBDATE()
  • setIfxDBSPACETEMP()
  • setIfxDBTEMP()
  • setIfxDBUPSPACE()
  • setIfxDELIMIDENT()
  • setIfxENABLE__HDRSWITCH()
  • setIfxENABLE_CACHE_TYPE()
  • setIfxFET_BUF_SIZE()
  • setIfxGL_DATE()
  • setIfxIFX_AUTOFREE()
  • setIfxIFX_CODESETLOB()
  • setIfxIFX_DIRECTIVES() (1), (2), (3)
  • setIfxIFX_EXTDIRECTIVES()
  • setIfxIFX_ISOLATION_LEVEL
  • setIfxIFX_LOCK_MODE_WAIT
  • setIfxIFX_USEPUT()
  • setIfxIFXHOST() (1), (2)
  • setIfxINFORMIXCONRETRY() (1), (2)
  • setIfxINFORMIXCONTIME()
  • setIfxINFORMIXOPCACHE()
  • setIfxINFORMIXSERVER_SECONDARY()
  • setIfxINFORMIXSTACKSIZE()
  • setIfxJDBCTEMP()
  • setIfxLDAP_IFXBASE()
  • setIfxLDAP_PASSWD()
  • setIfxLDAP_URL()
  • setIfxLDAP_USER()
  • setIfxLOBCACHE()
  • setIfxNEWCODESET()
  • setIfxNEWLOCALE() (1), (2)
  • setIfxNODEFDAC(String value)
  • setIfxOPT_GOAL()
  • setIfxOPTCOMPIND()
  • setIfxOPTOFC()
  • setIfxPATH()
  • setIfxPDQPRIORITY()
  • setIfxPLCONFIG()
  • setIfxPLOAD_LO_PATH() (1), (2)
  • setIfxPROTOCOLTRACE()
  • setIfxPROTOCOLTRACEFILE()
  • setIfxPROXY()
  • setIfxPSORT_DBTEMP()
  • setIfxPSORT_NPROCS()
  • setIfxSECURITY()
  • setIfxSQLH_FILE()
  • setIfxSQLH_TYPE()
  • setIfxSTMT_CACHE()
  • setIfxTRACE()
  • setIfxTRACEFILE()
  • setIfxUSEV5SERVER()
  • setImplicitCast()
  • setInt() (1), (2)
  • setJarFileSQLName() (1), (2)
  • setJarTmpPath()
  • setLength()
  • setLong()
  • setMaxFieldSize()
  • setMaxRows()
  • setNull() (1), (2)
  • setObject() (1), (2), (3), (4), (5)
  • setPassword()
  • setPortNumber()
  • setQualifier() (1), (2)
  • setQueryTimeout()
  • setReadOnly()
  • setRef()
  • setServerName()
  • setShort()
  • setSQLName() (1), (2), (3), (4), (5), (6)
  • setString() (1), (2), (3)
  • setTime()
  • setTimestamp()
  • setTypeMap() (1), (2)
  • setUDR()
  • setUDTExtName()
  • setUnicodeStream()
  • setUser()
  • setXXX() (1), (2), (3), (4), (5), (6), (7)
  • skipBytes()
  • SQLInput() (1), (2)
  • SQLOutput() (1), (2)
  • StringtoDOM()
  • toBytes()
  • toHexString()
  • toString() (1), (2)
  • unsupported
    • for distinct data types
    • for named rows
    • for opaque data types
    • for querying the database
  • updateObject() (1), (2), (3), (4)
  • updateRow()
  • updateRow(), and scroll cursors
  • updatesAreDetected()
  • updateString() (1), (2)
  • writeArray()
  • writeAsciiStream()
  • writeBinaryStream()
  • writeByte()
  • writeBytes() (1), (2)
  • writeCharacterStream() (1), (2), (3)
  • writeInt()
  • writeObject() (1), (2), (3), (4)
  • writeProperties()
  • writeRef() (1), (2), (3)
  • writeSQL() (1), (2), (3), (4), (5)
  • writeString() (1), (2)
  • writeXXX()
  • XMLtoInputStream
  • XMLtoString()
• Methods, DatabaseMetaData
• minPoolSize
• mitypes.h file
• moveToCurrentRow() method
• moveToInsertRow() method
• Multiple OUT parameters
• MultiRowCall.java example program
• myMoney.java example program

• Name-value pairs of database URL
• Named row data types
  • examples of
    • creating a Struct class for
    • using the SQLData interface
    • using the Struct interface
  • extensions for
  • generating using the ClassGenerator utility
  • intervals and collections in
  • opaque data type columns in
  • unsupported methods for
  • using the SQLData interface for
  • using the Struct interface for
• Named row example programs
• Native SQL date formats (1), (2)
• NEWCODESET environment variable (1), (2)
• NEWLOCALE environment variable (1), (2)
• NEWNLSMAP environment variable
• next() method (1), (2), (3), (4)
• NODEFDAC environment variable
• Nonnative SQL date formats (1), (2)

• Objects
  • IfxLocator
  • Locator
• ODBC
• Online help
• Online manuals
• Online notes (1), (2)
• onspaces utility
• Opaque data types
  • caching type information (1), (2)
  • creating
  • definition of
  • examples of
    • defining a class for
    • large objects
    • retrieving data
  • examples of creating
  • mappings for
  • steps for creating
  • unsupported methods
• Opaque type
  • SQL name
• Opaque types
  • and transactions
  • creating
• OPT_GOAL environment variable
• OPTCOMPIND environment variable
• OptimizedSelect.java example program
• OPTOFC environment variable (1), (2), (3)
• optofc.java example program (1), (2), (3)
• othersDeletesAreVisible() method
• othersInsertsAreVisible() method
• othersUpdatesAreVisible() method
• OUT parameter example programs
• OUT parameters
• OutputStreamWriter() method (1), (2), (3)
• Overloaded UDRs, removing
• Overview of IBM Informix JDBC Driver
• ownDeletesAreVisible() method
• ownInsertsAreVisible() method
• ownUpdatesAreVisible() method

• ParameterMetaData class (1), (2)
• PASSWORD connection property (1), (2)
• Passwords
  • setting in DataSource object
  • URL syntax of
• PATH environment variable
• PDQPRIORITY environment variable
• Performance
• PLCONFIG environment variable
• PLOAD_LO_PATH environment variable
• PooledConnection interface
• Port numbers, setting
  • in database URLs
  • in DataSource objects
  • in sqlhosts file or LDAP server
• PORTNO environment variable (1), (2)
• PORTNO_SECONDARY environment variable (1), (2)
• Precedence rules for date formats
• PREPARE statements, executing multiple
• PreparedStatement interface (1), (2), (3), (4), (5)
• prepareStatement() method
• previous() method
• Printed manuals
• Product CD, contents
• Properties class
• Property lists
• PropertyConnection.java example program
• propertyCycle
• PROXY environment variable
• Proxy server (1), (2)
  • example programs
• PSORT_DBTEMP environment variable
• PSORT_NPROCS environment variable
• put() method (1), (2)

• Qualifiers, binary, for INTERVAL data types
• Querying the database

• read() method
• Read-only connections
• readArray() method
• readAsciiStream() method
• readBinaryStream() method
• readByte() method
• readBytes() method (1), (2)
• readCharacterStream() method (1), (2), (3)
• readObject() method (1), (2), (3)
• readProperties() method
• readRef() method (1), (2), (3)
• readSQL() method (1), (2), (3), (4)
• readString() method (1), (2)
• Ref type
• refreshRow() method
• registerDriver() method
• Registering IBM Informix JDBC Driver
• registerOutParameter() method (1), (2), (3)
  • type mappings for
• relative() method
• Relative distinguished name (RDN)
• Release Notes
• Remote database access
• Remote method invocation (RMI)
• removeJar() method (1), (2)
• removeProperty() method
• removeUDR() method (1), (2)
• removeUDT() method
• Restrictions, driver
• Restrictions, server
• ResultSet class (1), (2)
• ResultSet interface (1), (2), (3), (4), (5)
• ResultSetMetaData interface
• Retrieving
  • database names
  • date values (1), (2)
  • Informix error message text
  • syntax error offset
  • user names
  • version information
  • XML data
• RMI
• ROLLBACK WORK statement
• row3.java example program
• rowDeleted() method
• rowInserted() method
• rowUpdated() method
• RSMetaData.java example program

• Sample-code conventions
• SAX (Simple API for XML)
• Sbspace
  • metadata area
  • name of (1), (2)
  • user-data area
• SBSPACENAME configuration parameter (1), (2)
• Schemas, IBM Informix JDBC Driver interpretation
• Screen reader
  • reading syntax diagrams
• Scroll cursors
• ScrollCursor.java example program (1), (2)
• scrubConnection() method (1), (2)
• Search, anonymous, of sqlhosts information
• SECURITY environment variable
• Selecting smart large objects
• SERIAL columns and scroll cursors
• SERIAL data type
• Serial.java example program
• SERIAL8 data type
• Server restrictions, limitations
• Service provider interface (SPI)
• Servlets
• SessionMgr class
• SessionMgr.class file (1), (2)
• set() method (1), (2)
• Set interface
• setAlignment() method
• setArray() method (1), (2)
• setAsciiStream() method (1), (2), (3), (4)
• setAutoAlignment() method
• setAutoCommit() method
• setAutoFree() method (1), (2)
• setBigDecimal() method (1), (2), (3)
• setBinaryStream() method (1), (2), (3), (4)
• setBlob() method
• setBoolean() method
• setByte() method
• setBytes() method
• setCatalog() method
• setCharacterStream() method
• setClassName() method
• setClob() method
• setCurrentPosition() method
• setDatabaseName() method
• setDataSourceName() method
• setDate() method
• setDescription() method
• setDouble() method
• setExplicitCast() method
• setFetchDirection() method (1), (2)
• setFetchSize() method (1), (2)
• setFieldCount() method
• setFieldLength() method
• setFieldName method
• setFieldType() method
• setFieldTypeName() method
• setFloat() method
• setIfxCLIENT_LOCALE() method
• setIfxCPMInitPoolSize() method
• setIfxCPMMaxAgeLimit() method
• setIfxCPMMaxConnections() method
• setIfxCPMMaxPoolSize() method
• setIfxCPMMinAgeLimit() method
• setIfxCPMMinPoolSize() method
• setIfxCPMServiceInterval() method
• setIfxCPMSwitchHDRPool() method
• setIfxCSM (String csm) method
• setIfxDB_LOCALE() method
• setIfxDBANSIWARN() method
• setIfxDBCENTURY() method
• setIfxDBDATE() method
• setIfxDBSPACETEMP() method
• setIfxDBTEMP() method
• setIfxDBUPSPACE() method
• setIfxDELIMIDENT() method
• setIfxENABLE__HDRSWITCH() method
• setIfxENABLE_CACHE_TYPE() method
• setIfxFET_BUF_SIZE() method
• setIfxGL_DATE() method
• setIfxIFX_AUTOFREE() method
• setIfxIFX_CODESETLOB() method
• setIfxIFX_DIRECTIVES() method (1), (2), (3)
• setIfxIFX_EXTDIRECTIVES() method
• setIfxIFX_ISOLATION_LEVEL method
• setIfxIFX_LOCK_MODE_WAIT method
• setIfxIFX_USEPUT() method
• setIfxIFXHOST() method (1), (2)
• setIfxINFORMIXCONRETRY() method (1), (2)
• setIfxINFORMIXCONTIME() method
• setIfxINFORMIXOPCACHE() method
• setIfxINFORMIXSERVER_SECONDARY() method
• setIfxINFORMIXSTACKSIZE() method
• setIfxJDBCTEMP() method
• setIfxLDAP_IFXBASE() method
• setIfxLDAP_PASSWD() method
• setIfxLDAP_URL() method
• setIfxLDAP_USER() method
• setIfxLOBCACHE() method
• setIfxNEWCODESET() method
• setIfxNEWLOCALE() method (1), (2)
• setIfxNODEFDAC(String value) method
• setIfxOPT_GOAL() method
• setIfxOPTCOMPIND() method
• setIfxOPTOFC() method
• setIfxPATH() method
• setIfxPDQPRIORITY() method
• setIfxPLCONFIG() method
• setIfxPLOAD_LO_PATH() method (1), (2)
• setIfxPROTOCOLTRACE() method
• setIfxPROTOCOLTRACEFILE() method
• setIfxPROXY() method
• setIfxPSORT_DBTEMP() method
• setIfxPSORT_NPROCS() method
• setIfxSECURITY() method
• setIfxSQLH_FILE() method
• setIfxSQLH_TYPE() method
• setIfxSTMT_CACHE() method
• setIfxTRACE() method
• setIfxTRACEFILE() method
• setIfxUSEV5SERVER() method
• setImplicitCast() method
• setInt() method (1), (2)
• setJarFileSQLName() method (1), (2), (3)
• setJarTmpPath() method
• setLength() method
• setLong() method
• setMaxFieldSize() method
• setMaxRows() method
• setNull() method (1), (2)
• setObject() method (1), (2), (3), (4), (5)
• setPassword() method
• setPortNumber() method
• setQualifier() method (1), (2)
• setQueryTimeout() method
• setReadOnly() method (1), (2)
• setRef() method
• setServerName() method
• setShort() method
• setSQLname() method
• setSQLName() method (1), (2), (3), (4), (5)
• setString() method (1), (2), (3)
• setTime() method
• setTimestamp() method
• Setting
  • autocommit
  • CLASSPATH environment variable (1), (2)
  • properties
• setTypeMap() method (1), (2)
• setUDR() method (1), (2), (3), (4), (5)
• setUDTExtName() method
• setUnicodeStream() method
• setup.jar file (1), (2)
• setup.std file
• setUser() method
• setXXX() method (1), (2), (3), (4), (5), (6), (7)
• Silent mode (1), (2)
• SimpleCall.java example program
• SimpleConnection.java example program
• SimpleSelect.java example program
• skipBytes() method
• Smart large object
  • access mode
  • attributes
  • buffering mode
  • byte data in
  • character data in
  • closing
  • data integrity
  • estimated size
  • extent size (1), (2), (3)
  • last-access time (1), (2), (3), (4), (5)
  • last-change time (1), (2)
  • last-modification time (1), (2)
  • locking
  • logging
  • logging of (1), (2), (3)
  • maximum I/O block size
  • metadata (1), (2), (3), (4)
  • minimum extent size
  • next-extent size (1), (2)
  • sbspace (1), (2)
  • size of (1), (2), (3), (4), (5)
  • transactions with (1), (2), (3)
  • unlocking (1), (2)
  • user data (1), (2), (3)
• Smart large object, implementation
  • classes
    • IfxBblob
    • IfxCblob
    • IfxLobDescriptor
    • IfxLocator
    • IfxLoStat
    • IfxSmartBlob
• Smart large object example programs (1), (2)
• Smart-large-object lock
  • exclusive (1), (2), (3), (4)
  • lock-all
  • releasing
  • share-mode (1), (2)
  • update
  • update mode
• Smart-large-object support in IDS
• Smart large objects
  • creating
  • inserting
  • selecting
• Smart large objects, accessing
• Software dependencies
• SQL code
• SQL date formats
  • native (1), (2)
  • nonnative (1), (2)
• SQL name (1), (2), (3)
• SQLCODE messages
• SQLData interface (1), (2), (3), (4), (5)
• SQLData objects
  • caching type information (1), (2)
• SQLException class (1), (2), (3), (4), (5)
• SQLH_TYPE environment variable
• SQLH_TYPE property
• SqlhDelete utility
• sqlhosts file
  • administration requirements for
  • and unsigned applets
  • group option
  • reading
  • URL syntax for
  • utilities for
• SqlhUpload utility
• SQLInput() method (1), (2)
• SQLInput interface
• SQLOutput() method (1), (2)
• SQLSTATE value
• Statement interface (1), (2), (3), (4)
• Statement local variables
• Status information
  • definition of
  • last-access time (1), (2)
  • last-change time (1), (2)
  • last-modification time (1), (2)
  • size (1), (2)
• STMT_CACHE environment variable
• Storage characteristics
  • attribute information
  • column-level (1), (2)
  • definition of
  • disk-storage information
  • system default (1), (2), (3)
  • system-specified (1), (2)
  • user-specified (1), (2)
• Strings, representing dates using
• StringtoDOM() method
• Struct interface (1), (2)
• Struct objects
  • caching type information (1), (2)
• Structured type (Struct)
• Sun JDBC 3.0 properties
• Support for 32K LVARCHAR
• Support for java.sql.ParameterMetaData interface
• Support for Multiple UDR OUT parameters
• Supported environment variables
• Syntax diagrams
  • conventions for
  • keywords in
  • reading in a screen reader
  • variables in
• Syntax error offset, retrieving
• Syntax of database URLs
• Syntax segment
• sysmaster database
• systables catalog
  • and code set conversion (1), (2)
  • and metadata

• TEXT data type
  • caching
  • code set conversion
  • code set conversion for
  • examples for
    • data inserts and updates
    • data retrieval
  • extensions for
• TextConv.java example program
• TextType.java example program (1), (2), (3)
• Threads, multiple, and concurrency
• TimeoutMgr class
• TimeoutMgr.class file (1), (2)
• toBytes() method
• TOC Notes
• toHexString() method
• toString() method (1), (2)
  • Methods
    • toString()
• Transaction
  • beginning
  • committing
  • rolling back
• Transaction management
  • smart large objects and (1), (2), (3)
• Transactions
  • distributed (1), (2), (3), (4)
  • handling
• Transactions, creating opaque types and UDRs
• TreeSet class
• TU_DAY variable (1), (2)
• TU_F1 variable
• TU_F2 variable
• TU_F3 variable
• TU_F4 variable
• TU_F5 variable (1), (2)
• TU_FRAC variable
• TU_HOUR variable
• TU_MINUTE variable
• TU_MONTH variable
• TU_SECOND variable
• TU_YEAR variable
• Tuple buffer (1), (2)
• Types interface (1), (2)
• Typographical conventions

• UDR.
  • See also User-defined routines.
• UDR Manager
  • example programs
• UDRManager class (1), (2), (3)
• UDRMetaData class (1), (2)
• UDT.
  • See also Opaque data types.
• udt_d1.java example program
• udt_d2.java example program
• udt_d3.java example program
• UDT Manager
  • example programs
• UDTManager class (1), (2)
• UDTMetaData class
• udtudrmgr package
• Unicode
  • and internationalization APIs
  • and the client code set
  • and the database code set
• Unicode characters
• Uninstalling
  • in console mode
  • in graphical mode
  • in silent mode
• Uninstalling driver
• Unnamed row data types
  • examples of
    • creating a Struct class for
    • using the Struct interface
  • extensions for
  • intervals and collections in
  • using the Struct interface for
• Unsupported methods
  • for distinct data types
  • for named rows
  • for opaque data types
  • for querying the database
• UpdateCursor1.java example program (1), (2)
• UpdateCursor2.java example program (1), (2)
• UpdateCursor3.java example program (1), (2)
• updateObject() method (1), (2), (3), (4)
• updateRow() method (1), (2)
• Updates, batch
• updatesAreDetected() method
• updateString() method (1), (2)
• URLs
  • database (1), (2)
  • syntax for LDAP server and sqlhosts file
• USER connection property (1), (2)
• User-defined routines
  • and named row parameters
  • and transactions
  • creating
  • definistion of
  • definition of
  • examples of creating
• User-defined routines, steps for creating
• User names, setting
  • in database URLs
  • in DataSource object
• USEV5SERVER environment variable
• Using
  • in an applet
  • in an application
• Utilities
  • ClassGenerator (1), (2)
  • jar
  • SqlhDelete
  • SqlhUpload

• Variables, in syntax diagrams
• Variables for binary qualifiers
• Version, of IBM Informix JDBC Driver
• Version class
• Visual disabilities
  • reading syntax diagrams

• writeArray() method
• writeAsciiStream() method
• writeBinaryStream() method
• writeByte() method
• writeBytes() method (1), (2)
• writeCharacterStream() method (1), (2), (3)
• writeInt() method
• writeObject() method (1), (2), (3), (4)
• writeProperties() method
• writeRef() method (1), (2), (3)
• writeSQL() method (1), (2), (3), (4), (5)
• writeString() method (1), (2)
• writeXXX() method

• XA (distributed transactions) (1), (2), (3), (4)
• XAConnection interface
• XADataSource interface
• xerces.jar file
• xerces parser
• XML documents
  • example programs
  • examples
  • setting up environment for
• XMLtoInputStream() method
• XMLtoString() method