Home | Previous Page | Next Page

Contents

In This Introduction

About This Manual

Software Dependencies

Assumptions About Your Locale

Demonstration Database

Documentation Conventions

Typographical Conventions

Feature, Product, and Platform

Syntax Diagrams

Example Code Conventions

Additional Documentation

Installation Guides

Informix Error Messages

Related Reading

Compliance with Industry Standards

IBM Welcomes Your Comments

System Catalog Tables

Objects That the System Catalog Tables Track

Using the System Catalog

Structure of the System Catalog

SYSAGGREGATES (IDS Only)

SYSAMS (IDS Only)

SYSATTRTYPES (IDS Only)

SYSCASTS (IDS Only)

SYSCHECKUDRDEP (IDS Only)

SYSCOLATTRIBS (IDS Only)

SYSDOMAINS (IDS Only)

SYSERRORS (IDS Only)

SYSEXTCOLS (XPS Only)

SYSEXTDFILES (XPS Only)

SYSEXTERNAL (XPS Only)

SYSFRAGAUTH (IDS Only)

SYSINDICES (IDS Only)

SYSINHERITS (IDS Only)

SYSLANGAUTH (IDS Only)

SYSLOGMAP (IDS Only)

SYSNEWDEPEND (XPS Only)

SYSOBJSTATE (IDS Only)

SYSOPCLASSES (IDS Only)

SYSREPOSITORY (XPS Only)

SYSROUTINELANGS (IDS Only)

SYSSEQUENCES (IDS Only)

SYSTABAMDATA (IDS Only)

SYSTRACECLASSES (IDS Only)

SYSTRACEMSGS (IDS Only)

SYSXTDDESC (IDS Only)

SYSXTDTYPEAUTH (IDS Only)

SYSXTDTYPES (IDS Only)

Information Schema (IDS Only)

Generating the Information Schema Views

Accessing the Information Schema Views

Structure of the Information Schema Views

Summary of Data Types

Description of Data Types

BIGINT (XPS Only)

BLOB (IDS Only)

BOOLEAN (IDS Only)

CHARACTER VARYING(m,r)

CLOB (IDS Only)

Distinct (IDS Only)

DOUBLE PRECISION

LIST(e) (IDS Only)

LVARCHAR(m) (IDS Only)

MULTISET(e) (IDS Only)

Opaque (IDS Only)

ROW, Named (IDS Only)

ROW, Unnamed (IDS Only)

SET(e) (IDS Only)

Built-In Data Types

Large-Object Data Types

Time Data Types

Extended Data Types (IDS Only)

Complex Data Types

Distinct Data Types

Opaque Data Types

Data Type Casting and Conversion

Using Built-in Casts

Using User-Defined Casts

Determining Which Cast to Apply

Casts for Distinct Types

What Extended Data Types Can Be Cast?

Operator Precedence

Environment Variables

Types of Environment Variables

Where to Set Environment Variables on UNIX

Where to Set Environment Variables on Windows

Using Environment Variables on UNIX

Setting Environment Variables in a Configuration File

Setting Environment Variables at Login Time

Syntax for Setting Environment Variables

Unsetting Environment Variables

Modifying an Environment-Variable Setting

Viewing Your Environment-Variable Settings

Checking Environment Variables with the chkenv Utility

Rules of Precedence

Using Environment Variables on Windows

Environment Settings for Native Windows Applications

Environment Settings for Command-Prompt Utilities

Rules of Precedence

List of Environment Variables

Environment Variables

ANSIOWNER (IDS Only)

BIG_FET_BUF_SIZE (XPS Only)

DBNLS (IDS Only)

DBONPLOAD (IDS Only)

DBREMOTECMD (UNIX Only)

DBTEMP (IDS Only)

ENVIGNORE (UNIX Only)

GLOBAL_DETACH_INFORM (XPS Only)

IBM_XPS_PARAMS (XPS Only)

IFMX_CART_ALRM (XPS Only)

IFMX_HISTORY_SIZE (XPS Only)

IFMX_OPT_FACT_TABS (XPS Only)

IFMX_OPT_NON_DIM_TABS (XPS Only)

IFX_DEF_TABLE_LOCKMODE (IDS Only)

IFX_NETBUF_PVTPOOL_SIZE (UNIX Only)

IFX_NETBUF_SIZE

IFX_PAD_VARCHAR (IDS Only)

IFX_UPDDESC (IDS Only)

INFORMIXC (UNIX Only)

INFORMIXCONCSMCFG (IDS Only)

INFORMIXCONRETRY

INFORMIXCONTIME

INFORMIXCPPMAP (IDS Only)

INFORMIXKEYTAB (UNIX Only)

INFORMIXOPCACHE (IDS Only)

INFORMIXSHMBASE (UNIX Only)

INFORMIXSQLHOSTS

INFORMIXSTACKSIZE

INFORMIXTERM (UNIX Only)

INF_ROLE_SEP (IDS Only)

INTERACTIVE_DESKTOP_OFF (Windows Only)

ISM_COMPRESSION

ISM_DEBUG_LEVEL

JAR_TEMP_PATH (IDS Only)

JAVA_COMPILER (IDS Only)

JVM_MAX_HEAP_SIZE (IDS Only)

LD_LIBRARY_PATH (UNIX Only)

LIBERAL_MATCH (XPS Only)

LIBPATH (UNIX Only)

OPT_GOAL (IDS and UNIX Only)

PLCONFIG (IDS Only)

PLOAD_LO_PATH (IDS Only)

PLOAD_SHMBASE (IDS Only)

RTREE_COST_ADJUST_VALUE (IDS Only)

SHLIB_PATH (UNIX Only)

STMT_CACHE (IDS Only)

TERM (UNIX Only)

TERMCAP (UNIX Only)

TERMINFO (UNIX Only)

THREADLIB (UNIX Only)

TOBIGINT (XPS Only)

USETABLEAME (IDS Only)

XFER_CONFIG (XPS Only)

Index of Environment Variables

Appendix A. The stores_demo Database

Appendix B. The sales_demo and superstores_demo Databases

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]