Home
|
Previous Page
|
Next Page
Contents
Introduction
About This Manual
Types of Users
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
Online Notes
Informix Error Messages
Manuals
Online Help
Accessibility
IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set
Compliance with Industry Standards
IBM Welcomes Your Comments
System Catalog Tables
In This Chapter
Objects That the System Catalog Tables Track
Using the System Catalog
Accessing the System Catalog
Updating System Catalog Data
Structure of the System Catalog
SYSAGGREGATES (IDS)
SYSAMS (IDS)
SYSATTRTYPES (IDS)
SYSBLOBS
SYSCASTS (IDS)
SYSCHECKS
SYSCHECKUDRDEP (IDS)
SYSCOLATTRIBS (IDS)
SYSCOLAUTH
SYSCOLDEPEND
SYSCOLUMNS
NOT NULL Constraints
Storing the Column Data Type
Opaque Data Types (IDS)
Storing Column Length
Storing Maximum and Minimum Values
SYSCONSTRAINTS
SYSDEFAULTS
SYSDEPEND
SYSDIRECTIVES (IDS)
SYSDISTRIB
SYSDOMAINS (IDS)
SYSERRORS (IDS)
SYSEXTCOLS (XPS)
SYSEXTDFILES (XPS)
SYSEXTERNAL (XPS)
SYSFRAGAUTH (IDS)
SYSFRAGMENTS
SYSINDEXES
SYSINDICES (IDS)
SYSINHERITS (IDS)
SYSLANGAUTH (IDS)
SYSLOGMAP (IDS)
SYSNEWDEPEND (XPS)
SYSOBJSTATE (IDS)
SYSOPCLASSES (IDS)
SYSOPCLSTR
SYSPROCAUTH
SYSPROCBODY
SYSPROCEDURES
SYSPROCPLAN
SYSREFERENCES
SYSREPOSITORY (XPS)
SYSROLEAUTH
SYSROUTINELANGS (IDS)
SYSSEQUENCES (IDS)
SYSSYNONYMS
SYSSYNTABLE
SYSTABAMDATA (IDS)
SYSTABAUTH
SYSTABLES
SYSTRACECLASSES (IDS)
SYSTRACEMSGS (IDS)
SYSTRIGBODY
SYSTRIGGERS
SYSUSERS
SYSVIEWS
SYSVIOLATIONS
SYSXTDDESC (IDS)
SYSXTDTYPEAUTH (IDS)
SYSXTDTYPES (IDS)
Information Schema (IDS)
Generating the Information Schema Views
Accessing the Information Schema Views
Structure of the Information Schema Views
Data Types
In This Chapter
Summary of Data Types
Description of Data Types
BIGINT (XPS)
BLOB (IDS)
BOOLEAN (IDS)
BYTE
CHAR(n)
CHARACTER(n)
CHARACTER VARYING(m,r)
CLOB (IDS)
DATE
DATETIME
DEC
DECIMAL
Distinct (IDS)
DOUBLE PRECISION
FLOAT(n)
INT
INT8
INTEGER
INTERVAL
LIST(e) (IDS)
LVARCHAR(m) (IDS)
MONEY(p,s)
MULTISET(e) (IDS)
Named ROW
NCHAR(n)
NUMERIC(p,s)
NVARCHAR(m,r)
Opaque (IDS)
REAL
ROW, Named (IDS)
ROW, Unnamed (IDS)
SERIAL(n)
SERIAL8(n)
SET(e) (IDS)
SMALLFLOAT
SMALLINT
TEXT
Unnamed ROW
VARCHAR(m,r)
Built-In Data Types
Large-Object Data Types
Time Data Types
Extended Data Types (IDS)
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
In This Chapter
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
AC_CONFIG
AFDEBUG
ANSIOWNER (IDS)
BIG_FET_BUF_SIZE (XPS)
CPFIRST
DBACCNOIGN
DBANSIWARN
DBBLOBBUF
DBCENTURY
DBDATE
DBDELIMITER
DBEDIT
DBFLTMASK
DBLANG
DBMONEY
DBNLS (IDS)
DBONPLOAD (IDS)
DBPATH
DBPRINT
DBREMOTECMD (UNIX)
DBSPACETEMP
DBTEMP (IDS)
DBTIME
DBUPSPACE
DEFAULT_ATTACH
DELIMIDENT
ENVIGNORE (UNIX)
FET_BUF_SIZE
GLOBAL_DETACH_INFORM (XPS)
IBM_XPS_PARAMS (XPS)
IFMX_CART_ALRM (XPS)
IFMX_HISTORY_SIZE (XPS)
IFMX_OPT_FACT_TABS (XPS)
IFMX_OPT_NON_DIM_TABS (XPS)
IFX_DEF_TABLE_LOCKMODE (IDS)
IFX_DIRECTIVES
IFX_EXTDIRECTIVES
IFX_LONGID
IFX_NETBUF_PVTPOOL_SIZE (UNIX)
IFX_NETBUF_SIZE
IFX_NO_TIMELIMIT_WARNING
IFX_PAD_VARCHAR (IDS)
IFX_UPDDESC (IDS)
IFX_XASTDCOMPLIANCE_XAEND
IMCADMIN
IMCCONFIG
IMCSERVER
INFORMIXC (UNIX)
INFORMIXCONCSMCFG (IDS)
INFORMIXCONRETRY
INFORMIXCONTIME
INFORMIXCPPMAP (IDS)
INFORMIXDIR
INFORMIXKEYTAB (UNIX)
INFORMIXOPCACHE (IDS)
INFORMIXSERVER
INFORMIXSHMBASE (UNIX)
INFORMIXSQLHOSTS
INFORMIXSTACKSIZE
INFORMIXTERM (UNIX)
INF_ROLE_SEP (IDS)
INTERACTIVE_DESKTOP_OFF (Windows)
ISM_COMPRESSION
ISM_DEBUG_FILE
ISM_DEBUG_LEVEL
ISM_ENCRYPTION
ISM_MAXLOGSIZE
ISM_MAXLOGVERS
JAR_TEMP_PATH (IDS)
JAVA_COMPILER (IDS)
JVM_MAX_HEAP_SIZE (IDS)
LD_LIBRARY_PATH (UNIX)
LIBERAL_MATCH (XPS)
LIBPATH (UNIX)
NODEFDAC
ONCONFIG
OPTCOMPIND
OPTMSG
OPTOFC
OPT_GOAL (IDS, UNIX)
PATH
PDQPRIORITY
PLCONFIG (IDS)
PLOAD_LO_PATH (IDS)
PLOAD_SHMBASE (IDS)
PSORT_DBTEMP
PSORT_NPROCS
RTREE_COST_ADJUST_VALUE (IDS)
SHLIB_PATH (UNIX)
STMT_CACHE (IDS)
TERM (UNIX)
TERMCAP (UNIX)
TERMINFO (UNIX)
THREADLIB (UNIX)
TOBIGINT (XPS)
USETABLEAME (IDS)
XFER_CONFIG (XPS)
Index of Environment Variables
Appendix A. The stores_demo Database
Structure of the Tables
The customer Table
The orders Table
The items Table
The stock Table
The catalog Table
The cust_calls Table
The call_type Table
The manufact Table
The state Table
The stores_demo Database Map
Primary-Foreign Key Relationships
The customer and orders Tables
The orders and items Tables
The items and stock Tables
The stock and catalog Tables
The stock and manufact Tables
The cust_calls and customer Tables
The call_type and cust_calls Tables
The state and customer Tables
Data in the stores_demo Database
customer Table
items Table
call_type Table
orders Table
stock Table
catalog Table
cust_calls Table
manufact Table
state Table
Appendix B. The sales_demo and superstores_demo Databases
The sales_demo Database (XPS)
Dimensional Model of the sales_demo Database
Structure of the sales_demo Tables
The superstores_demo Database (IDS)
Structure of the superstores_demo Tables
User-Defined Routines and Extended Data Types
Table Hierarchies
Referential Relationships
Appendix C. Accessibility
Dotted Decimal Syntax Diagrams
Glossary
Notices
Trademarks
Index
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]