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.
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.
Using environment variables on Windows™
Setting environment variables on Windows™
Using the system applet to change environment variables
The System applet provides a graphical interface to create, modify, and delete system-wide and user-specific variables. Environment variables that are set with the System applet are visible to all command-prompt sessions.

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.
  - 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.
    - Types of environment variables
    - Limitations on environment variables
    - Using environment variables on UNIX™
      You can set, unset, modify, and view environment variables. If you already use any HCL Informix® products, some or all of the appropriate environment variables might be set.
    - Using environment variables on Windows™
      - Where to set environment variables on Windows™
      - Setting environment variables on Windows™
        Using the system applet to change environment variables
        The System applet provides a graphical interface to create, modify, and delete system-wide and user-specific variables. Environment variables that are set with the System applet are visible to all command-prompt sessions.
        Using the command prompt to change environment variables
        You can change the setting of an environment variable at a command prompt.
        Using dbservername.cmd to initialize a command-prompt environment
        Each time that you open a Windows™ command prompt, it acts as an independent environment. Therefore, environment variables that you set within it are valid only for that particular command-prompt instance.
      - Rules of precedence for Windows™ environment variables
    - Environment variables in Informix® products
      The topics that follow discuss (in alphabetic order) environment variables that HCL Informix® database server products and their utilities use.
  - Appendixes
- 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.

Using the system applet to change environment variables

The System applet provides a graphical interface to create, modify, and delete system-wide and user-specific variables. Environment variables that are set with the System applet are visible to all command-prompt sessions.

About this task

To change environment variables with the System applet in the control panel

Procedure

Double-click the System applet icon from the Control Panel window.
Click the Environment tab near the top of the window.

Two list boxes display System Environment Variables and User Environment Variables. System Environment Variables apply to an entire system, and User Environment Variables apply only to the sessions of the individual user.
To change the value of an existing variable, select that variable. The name of the variable and its current value are in the boxes at the bottom of the window.
To add a new variable, highlight an existing variable and type the new variable name in the box at the bottom of the window.
Next, enter the value for the new variable at the bottom of the window and click Set .
To delete a variable, select the variable and click Delete.

Results

Important: In order to use the System applet to change System environment variables, you must belong to the Administrators group. For information about assigning users to groups, see your operating-system documentation.