INFORMIX
Informix Guide to SQL: Reference
Chapter 3: Environment Variables
Home Contents Index Master Index New Book

Index of Environment Variables

Figure 3-2 provides an overview of the uses for the various Informix and UNIX environment variables supported in Version 9.1. It serves as an index to general topics and lists the related environment variables and the pages where the environment variables are introduced.

Figure 3-2
Environment Variables Used with Informix Products

(1 of 8)

Topic Environment Variables Page

ANSI compliance

DBANSIWARN

3-17

Simple-large-object buffer

DBBLOBBUF

3-19

C compiler

INFORMIXC

3-44

C compiler: processing of multibyte
characters

CC8BITLEVEL

Guide to GLS Functionality

Client locale

CLIENT_LOCALE

Guide to GLS Functionality

Client/server

INFORMIXSERVER

3-49

INFORMIXSHMBASE

3-50

INFORMIXSTACKSIZE

3-51

CLIENT_LOCALE

Guide to GLS Functionality

DB_LOCALE

Guide to GLS Functionality

SERVER_LOCALE

Guide to GLS Functionality

Code-set conversion

CLIENT_LOCALE

Guide to GLS Functionality

DB_LOCALE

Guide to GLS Functionality

Communications Support Services

INFORMIXCONCSMCFG

3-45

INFORMIXKEYTAB

3-48

Compilation: ESQL/C

THREADLIB

3-65

Compiler

CC8BITLEVEL

Guide to GLS Functionality

INFORMIXC

3-44

Configuration file: ignore variables

ENVIGNORE

3-43

Configuration file: ON-Archive

ARC_DEFAULT

3-16

Configuration file: Universal Server

ONCONFIG

3-56

Configuration file: tctermcap

ARC_KEYPAD

3-16

Connecting

INFORMIXCONRETRY

3-47

INFORMIXSERVER

3-49

INFORMIXSQLHOSTS

3-51

Data distributions

DBUPSPACE

3-41

Database locale

DB_LOCALE

Guide to GLS Functionality

Database server

INFORMIXSERVER

3-49

SERVER_LOCALE

Guide to GLS Functionality

Date and time values

DBCENTURY

3-20

DBDATE

3-23,
Guide to GLS Functionality

GL_DATE

Guide to GLS Functionality

GL_DATETIME

Guide to GLS Functionality

DBTIME

3-38

Delimited identifiers

DELIMIDENT

3-42

Disk space

DBUPSPACE

3-41

Editor

DBEDIT

3-26

ESQL/C: C compiler

INFORMIXC

3-44

ESQL/C: DATETIME formatting

DBTIME

3-38

ESQL/C: delimited identifiers

DELIMIDENT

3-42

ESQL/C: multibyte filter

ESQLMF

Guide to GLS Functionality

ESQL/C: multibyte identifiers

CLIENT_LOCALE

Guide to GLS Functionality

ESQL/COBOL: DATETIME formatting

DBTIME

3-38

ESQL/COBOL: delimited identifiers

DELIMIDENT

3-42

ESQL/COBOL: multibyte identifiers

CLIENT_LOCALE

Guide to GLS Functionality

Executable programs

PATH

3-58

Fetch buffer size

FET_BUF_SIZE

3-43

Filenames: multibyte

GLS8BITSYS

Guide to GLS Functionality

Files: field delimiter

DBDELIMITER

3-26

Files: installation

INFORMIXDIR

3-47

Files: locale

CLIENT_LOCALE

Guide to GLS Functionality

DB_LOCALE

Guide to GLS Functionality

SERVER_LOCALE

Guide to GLS Functionality

Files: message

DBLANG

3-28

Files: temporary (Universal Server)

DBSPACETEMP

3-36

Files: temporary sorting

PSORT_DBTEMP

3-60

Files: termcap, terminfo

INFORMIXTERM

3-52

TERM

3-63

TERMCAP

3-63

TERMINFO

3-64

High-Performance Loader

DBONPLOAD

3-31

PLCONFIG

3-60

Identifiers: delimited

DELIMIDENT

3-42

Identifiers: multibyte characters

CLIENT_LOCALE

Guide to GLS Functionality

ESQLMF

Guide to GLS Functionality

INFORMIX-OnLine/Optical

INFORMIXOPCACHE

3-48

Installation

INFORMIXDIR

3-47

PATH

3-58

Language environment

DBLANG

3-28

Locale

CLIENT_LOCALE

Guide to GLS Functionality

DB_LOCALE

Guide to GLS Functionality

SERVER_LOCALE

Guide to GLS Functionality

Message files

DBLANG

3-28

Money values

DBMONEY

3-29,
Guide to GLS Functionality

Multibyte characters

CLIENT_LOCALE

Guide to GLS Functionality

DB_LOCALE

Guide to GLS Functionality

SERVER_LOCALE

Guide to GLS Functionality

Multibyte filter

ESQLMF

Guide to GLS Functionality

Multithreaded applications

THREADLIB

3-65

Nondefault locale

CLIENT_LOCALE

Guide to GLS Functionality

DB_LOCALE

Guide to GLS Functionality

SERVER_LOCALE

Guide to GLS Functionality

Universal Server: archiving

ARC_DEFAULT

3-16

ARC_KEYPAD

3-16

DBREMOTECMD

3-35

Universal Server: configuration parameters

ONCONFIG

3-56

Universal Server: parallel sorting

PSORT_DBTEMP

3-60

PSORT_NPROCS

3-61

Universal Server: role separation

INF_ROLE_SEP

3-53

Universal Server: shared memory

INFORMIXSHMBASE

3-50

Universal Server: stacksize

INFORMIXSTACKSIZE

3-51

Universal Server: tape management

ARC_DEFAULT

3-16

ARC_KEYPAD

3-16

DBREMOTECMD

3-35

Universal Server: temporary tables, sort files

DBSPACETEMP

3-36

Pathname: for C compiler

INFORMIXC

3-44

Pathname: for database files

DBPATH

3-31

Pathname: for executable programs

PATH

3-58

Pathname: for installation

INFORMIXDIR

3-47

Pathname: for message files

DBLANG

3-28

Pathname: for parallel sorting

PSORT_DBTEMP

3-60

Pathname: for remote shell

DBREMOTECMD

3-35

Printing

DBPRINT

3-34

Privileges

NODEFDAC

3-53

Program: printing

DBPRINT

3-34

Remote shell

DBREMOTECMD

3-35

Role separation

INF_ROLE_SEP

3-53

Routine: DATETIME formatting

DBTIME

3-38

Server

See Database server.

Server locale

SERVER_LOCALE

Guide to GLS Functionality

Shared memory

INFORMIXSHMBASE

3-50

Shell: remote

DBREMOTECMD

3-35

Shell: search path

PATH

3-58

Sorting

PSORT_DBTEMP

3-60

PSORT_NPROCS

3-61

DBSPACETEMP

3-36

SQL statement: CONNECT

INFORMIXSERVER

3-49

SQL statement: editing

DBEDIT

3-26

SQL statement: LOAD, UNLOAD

DBDELIMITER

3-26

SQL statement: UPDATE STATISTICS

DBUPSPACE

3-41

Stacksize

INFORMIXSTACKSIZE

3-51

Tables: temporary (Universal Server)

DBSPACETEMP

3-36

Temporary files

PSORT_DBTEMP

3-60

Temporary tables

DBSPACETEMP

3-36

Terminal handling

INFORMIXTERM

3-52

TERM

3-63

TERMCAP

3-63

TERMINFO

3-64

Utilities: DB-Access

DBDELIMITER

3-26

DBEDIT

3-26

INFORMIXTERM

3-52

DBFLTMASK

3-27

Utilities: dbexport

DBDELIMITER

3-26

Utilities: ON-Archive

ARC_DEFAULT

3-16

ARC_KEYPAD

3-16

DBREMOTECMD

3-35

Values: date and time

DBDATE

3-23,
Guide to GLS Functionality

DBTIME

3-38

Values: money

DBMONEY

3-29

Variables: overriding

ENVIGNORE

3-43




Informix Guide to SQL: Reference, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.