HCL Informix® V14.10 documentation
Welcome to the documentation for HCL Informix® 14.10 and related client tools and products. The current fix pack level of Informix is 14.10.xC11.
Example code conventions
Examples of SQL code occur throughout this publication. Except as noted, the code is not specific to any single HCL Informix® application development tool.
How to read the syntax diagrams
Syntax diagrams use special components to describe the syntax for SQL statements and commands.
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.
What's new in HCL Informix®
HCL Informix®14.10 has new, changed, and removed features.
Tutorials and examples
You can learn how to use some of the features and functionality of HCL Informix® by using tutorials, examples, and recorded demonstrations.
Accessibility features for HCL Informix® products
strives to provide products with usable access for everyone, regardless of age or ability.
Compliance with industry standards
HCL Informix® products are compliant
with various standards.
Java™ technology dependencies
HCL Informix® products and components
have Java™ software requirements for you to use Java tools and to create and run Java applications, including user-defined functions.
Assumptions about your locale
HCL Informix® products can support
many languages, cultures, and code sets. All the information related to character set,
collation and representation of numeric data, currency, date, and time that is used by a
language within a given territory and encoding is brought together in a single environment,
called a Global Language Support (GLS) locale.
Demonstration databases
Demonstration databases that contain sample data are provided with the HCL Informix® database server.
Release information
Review the release notes, documentation notes, and machine notes for essential information about an HCL Informix® product or fix pack.
GDPR Compliance Information
This document is for PID(s): 5725-D14, 5725-F59, 5725-A39, 5725-A40, 5737-B60, 5737-B86
Installing
These topics describe how to install HCL Informix® database servers, client products, and DataBlade® modules.
Informix® server
These topics describe how to install HCL Informix® database servers.
Client products
These topics describe how to install HCL Informix® client products.
DataBlade modules
These topics describe how to install HCL Informix® DataBlade® modules.
Informix® warehouse accelerator
These topics describe how to install HCL Informix® warehouse accelerator.
Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
System administration
These topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
Backup and Restore Guide
The Informix® Backup and Restore Guide describes how to use the Informix ON-Bar and ontape utilities to back up and restore database server data. These utilities enable you to recover your databases after data is lost or becomes corrupted due to hardware or software failure or accident.
Enterprise Replication
The HCL® Informix® Enterprise Replication Guide describes the concepts of data replication using Informix Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.
Migrating and upgrading
You can upgrade to the 14.10 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.
Migrating Informix® database systems
The Informix® Migration Guide describes how to move data manually between databases, servers, and computers.
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 Informix® Change Data Capture API Programmer's Guide describes how to program applications to process changed data from HCL Informix databases using the Informix Change Data Capture API.
Embedded SQLJ for HCL Informix®
The Informix® Embedded SQLJ User's Guide contains information about using Informix Embedded SQLJ.
ESQL/C Guide
The Informix® ESQL/C Programmer's Manual explains how to use Informix ESQL/C, 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 Informix® GLS User's Guide describes the Global Language Support (GLS) feature available in Informix products.
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 DataBlade® 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 Informix ODBC Driver, which is the Informix implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
.NET provider options
The Data Server Provider for .NET DB2® provider option is the preferred Informix® provider for developing new applications.
4GL
This topic provides a link to the Informix 4GL documentation.
Informix® JDBC Driver Guide
The Informix® JDBC Driver Programmer's Guide describes how to install, load, and use 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 Informix® OLE DB Provider Programmer's Guide describes the software requirements for using 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.
Embedding HCL Informix®
The Informix® Embeddability Guide describes how to embed HCL Informix in your applications.
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.
Informix® extensions and DataBlade® modules
These topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Creating extensions
You can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in Informix® databases.
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.
Dimensional databases
The Informix® Data Warehouse Guide provides information to help you design, implement, and manage dimensional databases, and describes the tools that you can use to create data warehouses and optimize your data warehouse queries.
Informix® Warehouse Accelerator
The Informix® Warehouse Accelerator Administration Guide includes information about installing and configuring the accelerator server, creating data marts, accelerators, and accelerated query tables (AQTs).
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.
Designing and Implementing a Database
The Informix® Database Design and Implementation Guide provides information to help you design, implement, and manage your Informix databases. It includes data models that illustrate different approaches to database design and shows you how to use structured query language (SQL) to implement and manage your databases.
JSON compatibility
You can use the popular JSON-oriented query language created by MongoDB to interact with data stored in HCL Informix®.
HCL Informix® JSON compatibility
The Informix® JSON Compatibility Guide describes how applications that use the popular JSON-oriented query language created by MongoDB can 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.
Security in HCL Informix®
The Informix® Security Guide documents methods for keeping your data secure by preventing unauthorized viewing and altering of data or database objects, including how to use the secure-auditing facility of the database server.
SQL programming
You can use the HCL Informix® implementation of the SQL language to develop applications for Informix database servers.
Guide to SQL: Syntax
The Informix® Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the Informix dialect of the SQL language.
Guide to SQL: Reference
The Informix® Guide to SQL: Reference contains the reference information for the system catalog tables, data types, and environment variables of the HCL Informix dialect of the SQL language, as implemented in HCL Informix. These topics also include information about the stores_demo, sales_demo, and superstore_demo databases that are included with HCL Informix.
Guide to SQL: Tutorial
The Informix® Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Troubleshooting HCL Informix®
Several troubleshooting techniques, tools, and resources are available for resolving problems that you encounter in your HCL Informix® database server environment.
Troubleshooting and support
To isolate and resolve problems with your HCL Informix® products, you can use the troubleshooting and support information, which contains instructions for using the problem-determination resources that are provided with your Informix products.