Jump to main content
Product Documentation
Customer Support
HCL Informix V14.10
HCL Informix®
V
14.10
documentation
Product overview
Installing
Administering
Migrating and upgrading
Client APIs and tools
Embedding
Informix®
Extending
Informix®
Data warehousing
Designing databases
JSON compatibility
Security
SQL programming
Troubleshooting
Informix®
Informix PDF guides
Search
Home
SQL programming
You can use the
HCL Informix®
implementation of the SQL language to develop applications for
Informix®
database servers.
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®
.
Appendixes
SQL programming
You can use the
HCL Informix®
implementation of the SQL language to develop applications for
Informix®
database servers.
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®
.
System catalog tables
The
system catalog
consists of tables and views that describe the structure of the database. Sometimes called the
data dictionary
, these table objects contain everything that the database knows about itself. Each system catalog table contains information about specific elements in the database. Each database has its own system catalog.
Data types
Every column in a table in a database is assigned a data type. The data type precisely defines the kinds of values that you can store in that column.
Environment variables
Various
environment variables
affect the functionality of your
HCL Informix®
products. You can set environment variables that identify your terminal, specify the location of your software and define other parameters.
Appendixes
The stores_demo Database
The
stores_demo
database contains a set of tables that describe an imaginary business and many of the examples in the
HCL Informix®
documentation are based on this database.
The superstores_demo database
The
superstores_demo
database illustrates an object-relational schema.
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.
Appendixes
The stores_demo Database
The
stores_demo
database contains a set of tables that describe an imaginary business and many of the examples in the
HCL Informix®
documentation are based on this database.
The superstores_demo database
The
superstores_demo
database illustrates an object-relational schema.
Rate this topic
5 stars
4 stars
3 stars
2 stars
1 star
Comment on this topic.
By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at
https://hcltechsw.com/resources/us-government-contact
. Do not include any personal data in this Comment box.