Welcome
Client APIs and tools
You can use the HCL Informix® implementation of client APIs to develop applications for Informix database servers.
Informix® JDBC Driver Guide
Globalization and date formats
Support for code-set conversion
Unicode to database code set

HCL Informix® V15.0 documentation
Welcome to the documentation for HCL Informix® 15.0 and related client tools and products.
Product overview
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.
Installing
These topics describe how to install HCL Informix® database servers, client products, and DataBlade® modules.
Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
Migrating and upgrading
You can upgrade to the 15.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.
Client APIs and tools
You can use the HCL Informix® implementation of client APIs to develop applications for Informix database servers.
- Change Data Capture API Programmer's Guide
- Embedded SQLJ for HCL Informix®
- ESQL/C Guide
- GLS User's Guide
  These topics describe the Global Language Support (GLS) feature available in HCL® Informix® products.
- Informix GLS API
- Informix® Object Interface for C++ Guide
- Informix® ODBC Driver Guide
- Informix .NET Core Provider
  Starting with CSDK 4.50.xC4, Informix .NET Core Provider built with .NET Core SDK/Runtime v3.1 is shipped for Windows x64 and Linux x86_64 platforms.
- Informix® .NET EF Core Provider Guide
- Informix 4GL/SQL
  These topics include information about HCL Informix®4GL and SQL.
- Informix® JDBC Driver Guide
  - Getting started
  - Connect to the database
  - Perform database operations
  - Work with Informix® types
  - Work with opaque types
  - Globalization and date formats
    - Support for Java™ and globalization
    - Support for HCL Informix® GLS variables
    - Support for DATE end-user formats
    - Precedence rules for end-user formats
    - Support for code-set conversion
    - User-defined locales
      HCL Informix® JDBC Driver uses the Java™ globalization API to manipulate international data.
    - Support for globalized error messages
  - Push data feature
  - Tuning and troubleshooting
  - Appendixes
- Informix International Language Supplement (ILS) User Guide
  These topics include information about the translated user interface files for Informix® UNIX™ products, locales, and code set conversion tables
- Informix® OLE DB Provider Guide
Embedding Informix®
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.
Extending Informix®
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 DataBlade® 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.
Data warehousing
In addition to designing and implementing Informix® dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries.
Designing databases
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.
JSON compatibility
You can use the popular JSON-oriented query language created by MongoDB to interact with data stored in HCL Informix®.
Security
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.
SQL programming
You can use the HCL Informix® implementation of the SQL language to develop applications for Informix database servers.
Troubleshooting HCL Informix®
Several troubleshooting techniques, tools, and resources are available for resolving problems that you encounter in your HCL Informix® database server environment.

Unicode to database code set

Java™ is Unicode based, so HCL Informix® JDBC Driver converts data between Unicode and the Informix® database code set. The code-set conversion value is extracted from the DB_LOCALE value specified at the time the connection is made. If the DB_LOCALE value is incorrect, a Database Locale information mismatch error occurs.

The DB_LOCALE value must be a valid Informix® locale, with a valid Informix® code-set name or number as shown in the compatibility table that follows. The following table maps the supported Java™ development kit encodings to Informix® code sets.


Informix® code set name	Informix® code set number	JDK code set
8859-1	819	8859_1
8859-2	912	8859_2
8859-3	57346	8859_3
8859-4	57347	8859_4
8859-5	915	8859_5
8859-6	1089	8859_6
8859-7	813	8859_7
8859-8	916	8859_8
8859-9	920	8859_9
8859-13	57390	ISO8859_13
ASCII	364	ASCII
sjis-s	932	SJIS
sjis	57350	SJIS
utf8	57372	UTF8
big5	57352	Big5
CP1250	1250	Cp1250
CP1251	1251	Cp1251
CP1252	1252	Cp1252
CP1253	1253	Cp1253
CP1254	1254	Cp1254
CP1255	1255	Cp1255
CP1256	1256	Cp1256
CP1257	1257	Cp1257
cp936	57357	ISO2022CN_GB
cp_949	57356	Cp949
GB18030-2000	5488	GB18030
KS5601	57356	Cp949
ksc	57356	Cp949
gb	57357	ISO2022CN_GB
GB2312-80	57357	ISO2022CN_GB
GB18030-2000	5488	GB18030
ujis	57351	EUC_JP

You cannot use the Informix® locale with a code set for which there is no JDK-supported encoding. This incorrect usage results in an Encoding or code set not supported error message.

The following table shows the supported locales.


Supported Locales
ar_ae	ar_bh	ar_kw	ar_om	ar_qa
ar_sa	bg_bg	ca_es	cs_cz	da_dk
de_at	de_ch	de_de	el_gr	en_au
en_ca	en_gb	en_ie	en_nz	en_us
es_ar	es_bo	es_cl	es_co	es_cr
es_ec	es_es	es_gt	es_mx	es_pa
es_pe	es_py	es_sv	es_uy	es_ve
et_ee	fi_fi	fr_be	fr_ca	fr_ch
fr_fr	hr_hr	hu_hu	is_is	it_ch
it_it	iw_il	ja_jp	ko_kr	mk_mk
nl_be	nl_nl	no_no	pl_pl	pt_br
pt_pt	ro_ro	ru_ru	sh_yu	sk_sk
sv_se	th_th	tr_tr	uk_ua	zh_cn
zh_tw