You can use the HCL Informix® implementation of client APIs to develop applications for Informix database servers.
The HCL® Informix® JDBC Driver Programmer's Guide describes how to install, load, and use HCL Informix JDBC Driver to connect to the Informix database from within a Java™ application or applet.
Read only mode not supported
Welcome to the documentation for HCL Informix® 15.0.0 and related client tools and products.
HCL Informix® is a fast and scalable database server that manages traditional relational, object-relational, and dimensional databases. Its small footprint and self-managing capabilities are suited to embedded data-management solutions.
These topics describe how to install HCL Informix® database servers, client products, and modules.
In addition to administering the database server, you can tune performance, replicate data, and archive data.
You can upgrade to the 15.0.0 release of HCL Informix® or migrate from other database servers to Informix. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the Informix database server can affect upgrading from a previous release.
The HCL® Informix® Change Data Capture API Programmer's Guide describes how to program applications to process changed data from HCL Informix databases using the HCL Informix Change Data Capture API.
The HCL® Informix® Embedded SQLJ User's Guide contains information about using IBM Informix Embedded SQLJ.
The HCL® Informix® Enterprise Replication Guide explains how to use , the Informix implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
The HCL® Informix® GLS User's Guide describes the Global Language Support (GLS) feature available in HCL Informix products.
The Informix GLS API Programmer's Guide describes the global language support (GLS) application programming interface (API) available in Informix® ESQL/C and HCL Informix modules.
The Informix® Object Interface for C++ Programmer's Guide describes how to develop HCL Informix client applications by using the object-oriented C++ programming language.
The Informix® ODBC Driver Programmer's Manual serves as a user guide and reference for HCL Informix ODBC Driver, which is the Informix implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
The HCL Data Server Provider for .NET IBM® DB2® provider option is the preferred Informix® provider for developing new applications.
This topic provides a link to the Informix 4GL documentation.
For your Java™ application to work with the internal server representation of HCL Informix® data types, use the IfxToJavaType class. For example, if your application is using the HCL Informix Change Data Capture API, you can use the IfxToJavaType class to interpret the byte stream.
Method not supported
Cannot create new object
Row/column index out of range
Cant load driver
Incorrect URL format
Incomplete input
Invalid qualifier
Cannot take null input
Error in date format
Syntax error in SQL escape clause
Error in time format
Error in timestamp format
Incorrect number of arguments
Type not supported
Syntax error
System or internal error
Invalid qualifier length
Invalid qualifier start code
Invalid qualifier end code
Invalid qualifier start or end code
Invalid interval string
Numeric character(s) expected
Delimiter character(s) expected
Character(s) expected
Extra character(s) found
Null SQL statement
Statement was not prepared
Unknown object type
Method cannot take argument
Connection not established
MaxRows out of range
Illegal cursor name
No active result
INFORMIXSERVER has to be specified
Cant instantiate protocol
No connection/statement establish yet
No metadata
No such column name
No current row
No statement created
Cannot convert to
Cannot convert from
Transactions not supported
No Transaction Isolation on non-logging db's
Invalid transaction isolation level
Cannot lock the connection
Number of input values does not match number of question marks
Method only for queries
Object is null
Must start with 'jdbc'
Invalid subprotocol
Invalid IP address
Invalid port number
Invalid database name
Invalid property format
Attempt to connect to a non 5.x server
Invalid fetch direction value
ResultSet type is TYPE_FETCH_FORWARD, direction can only be FETCH_FORWARD
Incorrect fetch size value
ResultSet type is TYPE_FORWARD_ONLY
Incorrect row value
A customized type map is required for this data type
Cannot find the SQLTypeName specified in the SQLData or Struct
Input value is not valid
No more data to read or write. Verify your SQLData class or getSQLTypeName()
Unable to create local file
Only TYPE_SCROLL_INSENSITIVE and TYPE_FORWARD_ONLY are supported
Type requested (%s) does not match row type information (%s) type
readObject/writeObject() only supports UDTs, Distincts, and complex types
Type mapping class must be a java.util.Collection implementation
Data within a collection must all be the same Java™ class and length
Index/Count out of range
Method can be called only once
Encoding or code set not supported
Locale not supported
Unable to convert JDBC escape format date string to localized date string
Unable to build a Date object based on localized date string representation
User name must be specified
Server does not support GLS variables DB_LOCALE, CLIENT_LOCALE or GL_DATE
Invalid complex type definition string
Row must contain data
Data in array does not match getBaseType() value
Row length provided (%s) does not match row type information (%s)
Row extended ID provided (%s) does not match row type information (%s)
Cannot find UDT, distinct, or named row (%s) in database
DBDATE setting must be at least four characters and no longer than six characters
A numeric year expansion is required after 'Y' character in DBDATE string
An invalid character is found in the DBDATE string after the 'Y' character
No 'Y' character is specified before the numeric year expansion value
An invalid character is found in DBDATE format string
Not enough tokens are specified in the string representation of a date value
Date string index out of bounds during date format parsing to build Date object
No more tokens are found in DBDATE string representation of a date value
No era designation found in DBDATE/GL_DATE string representation of date value
Numerical day value can not be determined from date string based on DBDATE
Numerical month value can not be determined from date string based on DBDATE
Not enough tokens specified in %D directive representation of date string
Not enough tokens specified in %x directive representation of date string
Connection without user/password not supported
User/Password does not match with datasource
Blob/Clob object is either closed or invalid
Not in Insert mode. Need to call moveToInsertRow() first
Cannot determine the table name
No serial, rowid, or primary key specified in the statement
Statement concurrency type is not set to CONCUR_UPDATABLE
Still in Insert mode. Call moveToCurrentRow() first
Function contains an output parameter
Name unnecessary for this data type
OUT parameter has not been registered
IN parameter has not been set
OUT parameter has not been set
Type name is required for this data type
Ambiguous java.sql.Type, use IfxRegisterOutParameter()
Function doesn't have an output parameter
Function parameter specified isnt an OUT parameter
Invalid directive used for the GL_DATE environment variable
Insufficient information given for building a time or timestamp Java™ object.
Exceeded maximum no. of connections configured for Connection Pool Manager
Distributed transactions (XA) are not supported by this database server.
Proxy Error: No database connection
Proxy Error: Input/output error while communicating with database
Cannot execute change permission command (chmod/attrib)
Same Jar SQL name already exists in the system catalog
Unable to copy jar file from client to server
No UDR information was set in UDRMetaData
SQL name of the jar file was not set in UDR/UDT MetaData
Cant create/remove UDT/UDR as no database is specified in the connection
JAR file on the client does not exist or cant be read
Invalid JAR file name
The 'javac' or 'jar' command failed
Same UDT SQL name already exists in the system catalog
UDT SQL name was not set in UDTMetaData
UDT field count was not set in UDTMetaData
UDT length was not set in UDTMetaData
UDT field name or field type was not set in UDTMetaData
No class files to be put into the jar
UDT java class must implement java.sql.SQLData interface
Specified UDT java class is not found
Specified UDT does not exists in the database.
Invalid support function type
The command to remove file on the client failed
Invalid UDT field number
Ambiguous java type(s) - can't use Object/SQLData as method argument(s)
Specified UDT field type has no Java™ type match
Invalid UDT field type
UDT field length was not set in UDTMetaData
Statement length exceeds the maximum
Statement already closed
Result set not open, operation not permitted
Invalid parameter value for setting maximum field size to a value less than zero
Result set not open, operation next not permitted. Verify that autocommit is OFF
An unexpected exception was thrown. See next exception for details
Unable to set JDK Version for the Driver
Already in local transaction, so cannot start XA transaction
These topics include information about the translated user interface files for Informix® UNIX™ products, locales, and code set conversion tables
The HCL Informix OLE DB Provider Programmer's Guide describes the software requirements for using HCL Informix® OLE DB Provider, show how to install and configure the provider for your use, and explain how to use Informix OLE DB Provider to enable client applications, such as ActiveX Data Object (ADO) applications and web pages, to access data on the Informix server.
When you embed HCL Informix®, you can use enterprise-class high-availability and high performance with embeddability features such as easy programmability, a small disk and memory footprint, and silent deployment.
Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix includes many built-in extensions that are fully integrated in the database server. Informix also provides modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix.
In addition to designing and implementing Informix® dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries.
The first step in creating a relational database is to construct a data model, which is a precise, complete definition of the data you want to store. After you prepare your data model, you must implement it as a database and tables. To implement your data model, you first select a data type for each column and then you create a database and tables and populate the tables with data. You can also implement fragmentation strategies and control access to your data.
You can use the popular JSON-oriented query language created by MongoDB to interact with data stored in HCL Informix®.
You can secure your Informix® database server and the data that is stored in your Informix databases. You can encrypt data, secure connections, control user privileges and access, and audit data security.
You can use the HCL Informix® implementation of the SQL language to develop applications for Informix database servers.
Several troubleshooting techniques, tools, and resources are available for resolving problems that you encounter in your HCL Informix® database server environment.
HCL Informix® does not support read-only mode.
