Welcome
Client APIs and tools
You can use the HCL Informix® implementation of client APIs to develop applications for Informix database servers.
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
User interface files
Country and region codes used by Informix®: IS0 3166

HCL Informix® V15.0.0 documentation
Welcome to the documentation for HCL Informix® 15.0.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 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.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
  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.
- Embedded SQLJ for HCL Informix®
  The HCL® Informix® Embedded SQLJ User's Guide contains information about using IBM Informix Embedded SQLJ.
- ESQL/C Guide
  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.
- GLS User's Guide
  The HCL® Informix® GLS User's Guide describes the Global Language Support (GLS) feature available in HCL Informix products.
- Informix GLS API
  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.
- Informix® Object Interface for C++ Guide
  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.
- Informix® ODBC Driver Guide
  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.
- .NET provider options
  The HCL Data Server Provider for .NET IBM® DB2® provider option is the preferred Informix® provider for developing new applications.
- HCL Informix 4GL
  This topic provides a link to the Informix 4GL documentation.
- Informix® JDBC Driver Guide
  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.
- 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
  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.
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 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.

Country and region codes used by Informix®: IS0 3166

The Country and Region codes used by Informix® are two-letter codes that are consistent with the IS0 3166 standard. Currently the following country and region codes are used. More codes might be later added.


Code	Language
ae	UAE
af	Afghanistan
al	Albania
am	Armenia
ar	Argentina
at	Austria
au	Australia
az	Azerbaijan
ba	Bosnia And Herzegowina
bd	Bangladesh
be	Belgium
bg	Bulgaria
bh	Bahrain
bn	Brunei Darussalam
bo	Bolivia
br	Brazil
by	Belarus
ca	Canada
ch	Switzerland
cl	Chile
cn	China
co	Colombia
cr	Costa Rica
cs	Serbia and Montenegro
cy	Cyprus
cz	Czech Republic
de	Germany
dj	Djibouti
dk	Denmark
do	Dominican Republic
dz	Algeria
ec	Ecuador
ee	Estonia
eg	Egypt
er	Eritrea
es	Spain
et	Ethiopia
fi	Finland
fo	Faroe Islands
fr	France
gb	United Kingdom
ge	Georgia
gh	Ghana
gl	Greenland
gr	Greece
gt	Guatemala
hk	Hong Kong
hn	Honduras
hr	Croatia
hu	Hungary
id	Indonesia
ie	Ireland
il	Israel
in	India
iq	Iraq
ir	Iran (Islamic Republic Of)
is	Iceland
it	Italy
jo	Jordan
jp	Japan
ke	Kenya
kh	Cambodia
kr	Korea, Republic Of
kw	Kuwait
kz	Kazakhstan
lb	Lebanon
li	Liechtenstein
lk	Sri Lanka
lt	Lithuania
lu	Luxembourg
lv	Latvia
ly	Libyan Arab Jamahiriya
ma	Morocco
mc	Monaco
md	Moldova, Republic Of
me	Montenegro
mk	Macedonia, The Former Yugoslav Republic Of
mo	Macau
mt	Malta
mx	Mexico
my	Malaysia
na	Namibia
ne	Niger
ng	Nigeria
ni	Nicaragua
nl	Netherlands
no	Norway
np	Nepal
nz	New Zealand
om	Oman
pa	Panama
pe	Peru
ph	Philippines
pk	Pakistan
pl	Poland
pr	Puerto Rico
pt	Portugal
py	Paraguay
qa	Qatar
ro	Romania
rs	Serbia
ru	Russian Federation
sa	Saudi Arabia
se	Sweden
sg	Singapore
si	Slovenia
sk	Slovak Republic
sn	Senegal
so	Somalia
sv	El Salvador
sy	Syrian Arab Republic
th	Thailand
tn	Tunisia
tr	Turkey
tw	Taiwan, Province Of China
tz	Tanzania, United Republic Of
ua	Ukraine
us	United States
uy	Uruguay
uz	Uzbekistan
ve	Venezuela
vn	Viet Nam
ye	Yemen
yu	Yugoslavia
za	South Africa