Home
SQL programming
You can use the HCL Informix® implementation of the SQL language to develop applications for Informix database servers.
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.
Modify data
Privileges on a database and on its objects

SQL programming
You can use the HCL Informix® implementation of the SQL language to develop applications for Informix database servers.
- Guide to SQL: Syntax
- 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.

Privileges on a database and on its objects

You can use the following database privileges to control who accesses a database:

Database-level privileges
Table-level privileges
Routine-level privileges
Language-level privileges
Type-level privileges
Sequence-level privileges
Fragment-level privileges

This section briefly describes database- and table-level privileges. For more information about database privileges, see the Informix® Database Design and Implementation Guide. For a list of privileges and a description of the GRANT and REVOKE statements, see the Informix® Guide to SQL: Syntax.