Index
A
- Access method
- definition of Glossary-1
- sysams information about 1-12
- Access privilege Glossary-1
- ALTER TABLE statement
- casting effects 2-26
- MODIFY NEXT SIZE clause 1-10
- ANSI compliance
- -ansi flag 3-17
- checking for (DBANSIWARN) 3-18
- DBANSIWARN environment variable 3-17
- icon Intro-10
- level Intro-16
- Application
- process Glossary-1
- program Glossary-1
- Application programming interface (API) Glossary-1
- Archiving
- personal default qualifier file (ARC_DEFAULT) 3-16
- remote shell for (DBREMOTECMD) 3-35
- tctermcap file for (ARC_KEYPAD) 3-16
- ARC_DEFAULT environment variable 3-16
- ARC_KEYPAD environment variable 3-16
- Argument Glossary-1
- Array
- definition of Glossary-2
- Attached index Glossary-2
- Auxiliary statements Glossary-2
B
- Binary Large Object (BLOB)
- buffer size variable (DBBLOBBUF) 3-19
- BLOB data type 2-33
- Glossary-2
- attributes in syscolattribs 1-20
- casting not available 2-33
- coltype code for 1-26
- inserting data 2-34
- blobpage Glossary-2
- blobspace 2-19, Glossary-2
- blobspaces
- size and location 1-18
- BOOLEAN data type 2-34
- Glossary-2
- coltype code for 1-26
- description of 2-34
- Boolean expression
- TEXT data type limitation 2-65
- Boolean function Glossary-2
- Bourne shell
- setting environment variables 3-8
- .profile file 3-8
- B-tree index Glossary-2
- Buffer
- size for fetch (FET_BUF_SIZE) 3-43
- Built-in data type 2-9 to 2-19
- Glossary-2
- casting, system-defined 2-25, 2-32
- INT 2-47
- BYTE data type 2-35
- Glossary-2
- coltype code for 1-24
- inserting data 2-35
- length (syscolumns) 1-29
- restrictions
- in Boolean expression 2-35
- with GROUP BY 2-35
- with LIKE or MATCHES 2-35
- with ORDER BY 2-35
- selecting a BYTE column 2-36
- sysblobs information 1-18
C
- C compiler (INFORMIXC) 3-44
- C shell
- setting environment variables 3-8
- .cshrc file 3-8
- .login file 3-8
- call_type table in stores7 database, columns in A-6
- Cast 2-25 to 2-32
- definition of Glossary-3
- distinct data type 2-31
- explicit 2-29, 2-30
- implicit 2-29, 2-30
- precedence of 2-30
- syscasts information 1-19
- system-defined 2-25 to 2-28, 2-30
- Casting function Glossary-3
- CHAR data type 2-36
- casts for 2-27
- collation order dependency 2-36
- coltype code for 1-24
- numeric values with 2-37
- CHARACTER data type 2-37
- Character data type
- collength (column length) information 1-27
- list of 2-9
- varying length 2-38
- Character string
- as DATETIME values 2-14, 2-43
- as INTERVAL values 2-51
- CHARACTER VARYING data type 2-38
- description of 2-38
- length 1-27
- Check constraint
- definition of Glossary-3
- syschecks information 1-20
- syscoldepend (dependencies) 1-23
- Checkpoint Glossary-3
- chkenv utility 3-10
- error message for 3-11
- Chunk Glossary-3
- Client Glossary-3
- Client/server
- architecture Glossary-3
- client stacksize (INFORMIXSTACKSIZE) 3-51
- connection statements Glossary-3
- default database (INFORMIXSERVER) 3-49
- shared memory communication segments (INFORMIXSHMBASE) 3-51
- CLOB data type 2-38
- attributes in syscolatribs 1-20
- casting not available 2-38
- code-set conversion of 2-39
- collation 2-39
- coltype code for 1-26
- definition of Glossary-3
- inserting data 2-39
- Cluster index Glossary-3
- Cluster key Glossary-3
- Cluster size Glossary-3
- Collation
- with CLOB data type 2-39
- Collation order Glossary-3
- NCHAR data type 1-12
- Collection Glossary-3
- Collection cursor Glossary-4
- Collection data type 2-22
- casting
- summary matrix 2-32
- coltype code for 1-24
- definition of Glossary-4
- LIST 2-51
- MULTISET 2-54
- SET 2-62
- sysattrtypes information about elements 1-17
- sysxtddesc contents for 1-62
- sysxtdtypes information 1-64
- Collection derived table
- definition of Glossary-4
- Collection variable Glossary-4
- Colon (:), delimiter in INTERVAL 2-50
- Color, setting INFORMIXTERM for 3-52
- Column
- constraints
- syconstraints 1-29
- syscoldepend 1-23
- sysreferences 1-49
- default value
- sysdefaults 1-30
- in stores7 database A-2 to A-7
- privileges
- syscolauth 1-22
- syscolumns description 1-23 to 1-31
- Column expression Glossary-4
- Column value
- maximum/minimum 1-29
- columns Information Schema view 1-68
- Command-line conventions
- elements of Intro-11
- example diagram Intro-12
- how to read Intro-12
- Comment icons Intro-9
- COMMIT WORK statement
- commit defined Glossary-4
- Commutator function Glossary-4
- Compiler
- environment variable for C (INFORMIXC) 3-44
- Complex data type 2-20 to 2-24
- collection types 2-22
- definition of Glossary-4
- row types 2-24
- sysattrtypes information about members 1-17
- Compliance
- icons Intro-10
- with industry standards Intro-16
- Composite index Glossary-4
- Concurrency
- description of Glossary-4
- Configuration file
- database server (ONCONFIG) 3-56
- ON-Archive utility (ARC_DEFAULT) 3-16
- tctermcap (TERMCAP) 3-16
- CONNECT DEFAULT statement
- INFORMIXSERVER environment variable effect 3-49
- Connecting to data
- INFORMIXCONRETRY environment variable 3-45
- INFORMIXCONTIME environment variable 3-46
- Connection Glossary-4
- INFORMIXCONRETRY environment variable 3-45
- INFORMIXCONTIME environment variable 3-46
- Constant Glossary-5
- Constraint
- definition of Glossary-5
- not null 1-23
- object mode (sysobjstate) 1-40
- syscoldepend (dependencies) 1-23
- sysconstraints information about 1-29
- Correlation name
- definition of Glossary-5
- CREATE SCHEMA statement
- example 1-4
- CREATE VIEW statement
- sysviews information 1-8
- Cursor
- definition of Glossary-5
- Cursor function Glossary-5
- customer table in stores7 database A-2
- cust_calls table in stores7 database, columns in A-6
D
- Data distribution Glossary-5
- Data distributions
- disk space for (DBUPSPACE) 3-41
- sysdistrib information 1-32
- Data integrity
- definition of Glossary-5
- statements Glossary-5
- Data manipulation statements Glossary-5
- Data replication Glossary-6
- Data type
- approximate 1-68
- casting 2-25 to 2-32
- definition of Glossary-6
- exact numeric 1-68
- extended 2-20, 2-71
- floating-point 2-47
- for sequential integer 2-59, 2-61
- for unique numeric code 2-59, 2-61
- INT 2-47
- simple large object 2-19
- smart large object 2-17
- summary table 2-7
- Database
- data types 2-33
- defined Glossary-6
- map of
- stores7 A-8
- stores7 description of A-1
- tables in (systables) 1-54
- Database administrator (DBA) Glossary-6
- Database application Glossary-6
- Database environment Glossary-6
- Database management system (DBMS) Glossary-6
- Database object Glossary-6
- state of (sysobjstate) 1-40
- Database server
- attributes in Information Schema view 1-70
- default for connection (INFORMIXSERVER) 3-49
- Database, stores 7 A-1
- Datablade
- message information (syserrors) 1-33
- DataBlade API Glossary-6
- DataBlade module Glossary-6
- DATE data type 2-39
- casting to integer 2-28
- converting to DATETIME 2-28
- DATETIME, INTERVAL with 2-10, 2-13
- format for (DBDATE) 3-23
- international date formats 2-40
- source data 2-14
- syscolumns coltype code for 1-24
- two-digit year values and DBCENTURY variable 2-40
- year digits for (DBCENTURY) 3-20
- DATETIME data type 2-40
- character string values 2-43
- converting to DATE 2-28
- converting to integer 2-28
- DATE INTERVAL with 2-10 to 2-15
- EXTEND function with 2-13
- extending fields in 2-11
- field qualifiers 2-41
- format for (DBTIME) 3-38
- international formats 2-44
- length (syscolumns) 1-28
- source data 2-14
- syscolumns coltype code for 1-24
- two-digit year values and DBDATE variable 2-43
- year digits for (DBCENTURY) 3-20
- dbaccessdemo7 script Intro-6
- DBANSIWARN environment variable 3-17
- DBBLOBBUF environment variable 3-19
- DBCENTURY environment variable 3-20
- DBDATE with 3-25
- DBDATE environment variable 3-23
- DBDELIMITER environment variable 3-26
- DBEDIT environment variable 3-26
- DBFLTMASK environment variable 3-27
- DBLANG environment variable 3-28
- DBMONEY environment variable 3-29
- DBONPLOAD environment variable 3-31
- DBPATH environment variable 3-31
- DBPRINT environment variable 3-34
- DBREMOTECMD environment variable 3-35
- dbspace
- definition of Glossary-6
- dbspaces
- size and location 1-18
- DBSPACETEMP environment variable 3-36
- DBTEMP environment variable 3-37
- DBTIME environment variable 3-38
- DBUPSPACE environment variable 3-41
- DECIMAL data type
- casts for 2-27
- description of 2-45
- disk storage 2-45
- fixed-point 2-45
- floating-point 2-44
- length (syscolumns) 1-27
- syscolumns coltype code for 1-24
- Decimal digits, display of 3-27
- Decimal point (.)
- as delimiter in INTERVAL 2-50
- Default locale Intro-5
- Default value Glossary-7
- sysdefaults information 1-30
- DELIMIDENT environment variable 3-42
- Delimiter
- for DATETIME values 2-42
- for INTERVAL values 2-50
- Demonstration database Intro-6
- map of A-8
- structure of tables A-2
- tables in A-2 to A-7
- Detached index Glossary-7
- Diagnostics table
- sysviolations information 1-61
- Disabled object mode
- defined Glossary-7
- Disk space
- distribution data size 3-41
- Distinct data type
- casts 2-31
- definition of 2-46, Glossary-7
- sysxtddesc contents for 1-62
- Documentation conventions
- command-line Intro-10
- icon Intro-9
- sample-code Intro-13
- typographical Intro-8
- Documentation notes Intro-15
- Documentation, types of
- documentation notes Intro-15
- error message files Intro-15
- machine notes Intro-15
- on-line manuals Intro-14
- printed manuals Intro-14
- release notes Intro-15
- DOUBLE PRECISION data type 2-47
- Duplicate index Glossary-7
- Dynamic routine-name specification Glossary-7
E
- Editor, specifying with DBEDIT 3-26
- Element Glossary-7
- Element type Glossary-7
- Enabled object mode
- defined Glossary-7
- End-user routine Glossary-7
- ENVIGNORE environment variable 3-43
- chkenv utility with 3-11
- Environment configuration file 3-6
- chkenv utility for 3-10
- common ($INFORMIXDIR/etc/informix.rc) 3-11
- debugging with chkenv 3-11
- ignoring errors in (ENVIGNORE) 3-11
- locations 3-11
- private (.informix/informix.rc) 3-11
- Environment variable 3-5 to 3-72
- ARC_DEFAULT 3-16
- ARC_KEYPAD 3-16
- checking with chkenv utility 3-10
- configuration file with 3-6
- DBANSIWARN 3-17
- DBBLOBBUF 3-19
- DBCENTURY 3-20
- DBDATE 3-23
- DBDELIMITER 3-26
- DBEDIT 3-26
- DBFLTMASK 3-27
- DBLANG 3-28
- DBMONEY 3-29
- DBONPLOAD 3-31
- DBPATH 3-31
- DBPRINT 3-34
- DBREMOTECMD 3-35
- DBSPACETEMP 3-36
- DBTIME 3-38
- DBUPSPACE 3-41
- DELIMIDENT 3-42
- ENVIGNORE 3-43
- FET_BUF_SIZE 3-43
- INFORMIXC 3-44
- INFORMIXCONRETRY 3-45
- INFORMIXCONTIME 3-46
- INFORMIXDIR 3-47
- INFORMIXOPCACHE 3-48
- INFORMIXSERVER 3-49
- INFORMIXSHMBASE 3-50
- INFORMIXSQLHOSTS 3-51
- INFORMIXSTACKSIZE 3-51
- INFORMIXTERM 3-52
- INF_ROLE_SEP 3-53
- listed, by topic 3-65
- modifying 3-9
- NODEFDAC 3-56
- ONCONFIG 3-56
- OPTCOMPIND 3-57
- overriding a setting (ENVIGNORE) 3-43
- PATH 3-58
- PDQPRIORITY 3-58
- PLCONFIG 3-60
- PSORT_DBTEMP 3-60
- PSORT_NPROCS 3-61
- rules of precedence 3-11
- setting 3-6
- setting shell 3-8
- TERM 3-63
- TERMCAP 3-63
- TERMINFO 3-64
- THREADLIB 3-65
- types of 3-5
- view current setting 3-9
- en_us.8859-1 locale Intro-5
- Error message files Intro-15
- Error messages
- creating new messages 1-34
- ESQL/C Smart-Large-Object API Glossary-8
- Exclusive access Glossary-8
- Exclusive lock Glossary-8
- Executable file location
- PATH environment variable 3-58
- Explicit cast Glossary-8
- Explicit connection Glossary-8
- Explicit select list Glossary-8
- EXTEND function
- example 2-13
- Extended data type 2-20, 2-71, Glossary-8
- Extension, to SQL
- checking for with DBANSIWARN environment variable 3-17
- Extent
- changing size of system table 1-10
- External function
- definition of Glossary-8
- name in sysprocedures 1-46
- External procedure
- definition of Glossary-8
- External routine
- compiling multithreaded applications 3-65
- definition of Glossary-8
- languages supported in sysroutinelangs 1-51
- sysprocauth (Execute privileges) information 1-44
- sysprocedures information 1-46
- External space Glossary-8
F
- Feature icons Intro-10
- Features, product Intro-6
- FET_BUF_SIZE environment variable 3-43
- Field Glossary-8
- Field delimiter (DBDELIMITER) 3-26
- File
- temporary
- dbspace (DBSPACETEMP) 3-36
- directory for sorting (PSORT_DBTEMP) 3-60
- directory for (DBTEMP) 3-38
- temporary, sorting 3-60
- termcap, terminfo 3-52, 3-63
- FILETOBLOB function 2-33
- FILETOCLOB function 2-38
- Filter Glossary-9
- Fixed point 2-45
- FLOAT data type 2-47
- casts for 2-27
- syscolumns coltype code for 1-24
- Floating point 2-44
- single-precision (FLOAT) 2-47
- Foreign key Glossary-9
- Format
- DATETIME, specifying (DBTIME) 3-38
- DATE, specifying (DBDATE) 3-24
- MONEY, specifying with DBMONEY 3-29
- Fragment
- privileges
- sysfragauth information 1-34
- Fragmentation
- PDQ priority, setting (PDQPRIORITY) 3-58
- sysfragments information 1-36
- Function
- definition of Glossary-9
- used with BLOB columns 2-33
G
- Gateway Glossary-9
- Global Language Support (GLS) Intro-5
- locale
- GL_COLLATE and GL_TYPE in systables 1-56
- systables information 1-56
- Global variable Glossary-9
- GLS API Glossary-9
H
- Hash rule Glossary-9
- High-Performance Loader, environment variable for 3-31, 3-60
- Host variable Glossary-9
I
- Icons
- comment Intro-9
- compliance Intro-10
- feature Intro-10
- Identifier Glossary-10
- IFX_DEFERRED_PREPARE environment variable 3-55
- Implicit cast 2-29, Glossary-10
- Implicit connection Glossary-10
- Implicit select list Glossary-10
- Index Glossary-10
- attached Glossary-2
- object mode (sysobjstate) 1-40
- on routines 1-48
- sysindices information 1-37
- threads for 3-62
- Index fragment Glossary-10
- IndexKey structure
- fields in 1-38, 1-39
- Industry standards, compliance with Intro-16
- Information Schema views
- accessing 1-67
- columns view 1-68
- description of 1-65 to 1-71
- generating 1-66
- server_info view 1-70
- sql_languages view 1-70
- tables view 1-67
- Informix extension checking, specifying with DBANSIWARN 3-17
- Informix user ID Glossary-10
- Informix user password Glossary-10
- INFORMIXC environment variable 3-44
- INFORMIXCONCSMCFG environment variable 3-45
- INFORMIXCONRETRY environment variable 3-45
- INFORMIXCONTIME environment variable 3-46
- INFORMIXDIR environment variable 3-47
- INFORMIXDIR/bin directory Intro-6
- INFORMIXKEYTAB environment variable 3-48
- INFORMIXOPCACHE environment variable 3-48
- INFORMIXSERVER environment variable 3-49
- INFORMIXSHMBASE environment variable 3-50
- INFORMIXSTACKSIZE environment variable 3-51
- INFORMIXTERM environment variable 3-52
- Informix, environment configuration file 3-6
- informix.rc file 3-6
- INF_ROLE_SEP environment variable 3-53
- Inheritance
- definition of Glossary-10
- Input parameter Glossary-10
- Input support function 2-53
- Installation Glossary-10
- Installation directory, specifying with INFORMIXDIR 3-48
- Installation files, INFORMIXDIR environment variable 3-47
- INT data type 2-47
- INT8 data type 2-47
- casts for 2-27, 2-28
- syscolumns coltype code for 1-24
- INTEGER data type 2-48
- casts for 2-27, 2-28
- length (syscolumns) 1-27
- syscolumns coltype code for 1-24
- Intensity attributes, setting INFORMIXTERM for 3-52
- Interquery parallelization Glossary-11
- INTERVAL data type 2-48
- DATE, DATETIME with 2-10, 2-15 to 2-16
- expressions with 2-10
- EXTEND function with 2-13
- field delimiters 2-50
- length (syscolumns) 1-28
- syscolumns coltype code for 1-24
- Intraquery parallelization Glossary-11
- ISO 8859-1 code set Intro-5
- Isolation Glossary-11
- items table in stores7 database, columns in A-4
- iterator function Glossary-11
J
- Jagged rows Glossary-11
K
- Key Glossary-11
- Keyword Glossary-11
- Korn shell
- setting environment variables 3-8
- .profile file 3-8
L
- Language
- supported
- sysroutinelangs information 1-51
- Language environment
- DBLANG 3-28
- setting with DBLANG 3-28
- Large object 2-16
- character 2-38
- definition of Glossary-11
- Library Glossary-11
- shared Glossary-17
- Link Glossary-11
- LIST Glossary-11
- LIST data type 2-51
- syscolumns coltype code for 1-24
- Literal Glossary-11
- Local variable Glossary-11
- Locale Intro-5
- Lock Glossary-12
- Lock mode Glossary-12
- Locking Glossary-12
- Locking granularity Glossary-12
- LOCOPY function 2-33, 2-38
- LOTOFILE function 2-33, 2-38
- LVARCHAR Glossary-12
M
- Machine notes Intro-15
- Major features Intro-6
- Message files, specifying subdirectory with DBLANG 3-28
- Messages
- error
- creating 1-34
- (syserrors) 1-33
- informational
- creating 1-34
- (syserrors) 1-33
- warning
- creating 1-34
- (syserrors) 1-33
- Mirroring Glossary-12
- MONEY data type 2-53
- casts for 2-27
- display format specified with DBMONEY 3-29
- international money formats 2-54
- length(syscolumns) 1-27
- syscolumns coltype code for 1-24
- MULTISET Glossary-12
- MULTISET data type 2-54
- syscolumns coltype code for 1-24
- Multithreaded external applications
- compiling 3-65
N
- Named row data type Glossary-12
- Named row type 2-56 to 2-57
- casting permitted 2-32
- NCHAR data type
- collation order 2-57
- multibyte characters 2-57
- syscolumns coltype code for 1-24
- Negator function Glossary-12
- Network environment variable
- DBPATH 3-31
- Node Glossary-12
- NODEFDAC environment variable
- description of 3-56
- Noncursor
- function Glossary-12
- noncursor procedure Glossary-13
- Nonprintable characters
- with CHAR data type 2-37
- Non-variant function Glossary-13
- Not null constraint 1-23, Glossary-13
- Null value Glossary-13
- allowed or not allowed 1-25
- syscolumns coltype code for 1-24
- testing in BYTE expression 2-35
- TEXT data type and 2-65
- Numeric data type
- casting between 2-26
- casting to characters 2-27
- list of 2-9
- NVARCHAR data type 2-58
- collation order 2-58
- length (syscolumns) 1-28
- multibyte characters 2-58
- syscolumns coltype code for 1-24
O
- Object mode Glossary-13
- sysobjstate information 1-40
- Object-relational database Glossary-13
- ON-Archive configuration file (ARC_DEFAULT) 3-16
- ONCONFIG environment variable 3-56
- On-line manuals Intro-14
- Opaque data type 2-58
- description of Glossary-13
- smart large objects with 2-17
- storage of 2-53
- syscolumns coltype code for 1-24
- sysxtddesc contents for 1-62
- Opaque type
- cast matrix 2-32
- Operator Glossary-13
- binding Glossary-13
- function Glossary-13
- Operator class
- definition Glossary-13
- sysopclasses information 1-42
- OPTCOMPIND environment variable, values 3-57
- orders table in stores7 database, columns in A-3
- Output support function 2-53
P
- Pad Glossary-14
- Page Glossary-14
- Parallel distributed queries
- priority level (PDQPRIORITY) 3-58
- Parallel sorting threads (PSORT_NPROCS) 3-60
- Parallelism Glossary-14
- Parameter Glossary-14
- PATH environment variable 3-58
- Pathname
- C compiler (INFORMIXC) 3-44
- database server (DBPATH) 3-31
- executable programs (PATH) 3-58
- installation (INFORMIXDIR) 3-47
- message files (DBLANG) 3-28
- parallel sorting (PSORT_DBTEMP) 3-60
- remote shell (DBREMOTECMD) 3-35
- PDQ
- optimizing joins (OPTCOMPIND) 3-57
- prioritizing (PDQPRIORITY) 3-58
- Permission Glossary-14
- PLCONFIG environment variable 3-60
- Pointer Glossary-14
- Polymorphism Glossary-14
- Precedence, rules for environment variables 3-11
- predefined data type Glossary-14
- Predicate lock Glossary-14
- PREPARE statement
- deferred execution 3-55
- Prepared statement Glossary-14
- version number 1-56
- Preprocessor Glossary-14
- Primary access method Glossary-14
- Primary key
- definition of Glossary-14
- Primary key constraint
- definition of Glossary-14
- Print program 3-34
- Printed manuals Intro-14
- Printing with DBPRINT 3-34
- Privilege Glossary-14
- column-specific
- syscolauth information 1-22
- database-level
- sysusers information 1-60
- public
- NODEFDAC environment variable 3-56
- table fragment
- sysfragauth information about 1-34
- table-level
- syscolauth sample entry 1-8
- systabauth information 1-8, 1-53
- Usage
- sysxtdtypeauth information 1-63
- Procedural statement Glossary-15
- Procedure
- description of Glossary-15
- Program block Glossary-15
- Projection Glossary-15
- Protected routine 1-48
- PSORT_DBTEMP environment variable 3-60
- PSORT_NPROCS environment variable 3-61
Q
- Query
- optimization information (sysprocplan) 1-48
- Quoted string
- DATE, DATETIME 2-14
R
- Referential constraint
- definition of Glossary-15
- sysreferences information 1-49
- Relational database Glossary-15
- Release notes Intro-15
- Role
- separation (INF_ROLE_SEP) 3-53
- sysroleauth information 1-50
- ROLLBACK WORK statement
- roll back defined Glossary-15
- Root supertype Glossary-15
- Routine Glossary-15
- execution plan (sysprocplan) 1-48
- optimization information (sysprocplan) 1-48
- overloading Glossary-15
- protected 1-48
- resolution Glossary-16
- signature Glossary-16
- sysprocbody contains source 1-45
- sysprocedures information 1-46
- Row type 2-24
- casting permitted 2-32
- definition of Glossary-16
- field information (sysattrtypes) 1-17
- sysattrtypes information 1-17
- syscolumns coltype code for 1-24
- sysxtddesc contents for 1-62
- sysxtdtypes information 1-64
- Row variable
- definition of Glossary-16
- R-tree index Glossary-15
S
- Sample-code conventions Intro-13
- sbspace 2-17
- definition of Glossary-16
- sbspaces
- size and location 1-18
- Schema Glossary-16
- Scope Glossary-16
- Scroll cursor
- definition of Glossary-16
- Secondary access method Glossary-17
- definition of Glossary-17
- Select cursor
- definition of Glossary-17
- Selection Glossary-17
- Selectivity Glossary-17
- Sequential cursor
- definition of Glossary-17
- Sequential integers
- with SERIAL data type 2-59
- with SERIAL8 data type 2-61
- SERIAL data type 2-59
- inserting values 2-60
- length (syscolumns) 1-27
- resetting values 2-60
- syscolumns coltype code for 1-24
- SERIAL8 data type 2-61
- inserting values 2-62
- length (syscolumns) 1-27
- resetting values 2-62
- syscolumns coltype code for 1-24
- Serializable Glossary-17
- Server
- name Glossary-17
- number Glossary-17
- server_info Information Schema view 1-70
- Session Glossary-17
- SET data type 2-62, Glossary-17
- syscolumns coltype code for 1-24
- Setting environment variables 3-8
- Shared library Glossary-17
- Shared memory Glossary-17
- client (INFORMIXSHMBASE) 3-50
- parameter file (ONCONFIG) 3-57
- Shell
- file for environment variables 3-8
- remote (DBREMOTECMD) 3-35
- remote, overriding (DBREMOTECMD) 3-35
- search path (PATH) 3-58
- Simple large object 2-19, Glossary-18
- cluster key Glossary-3
- length (syscolumns) 1-29
- location 1-18
- sysblobs information 1-18
- Simple predicate Glossary-18
- Singleton SELECT statement
- definition of Glossary-18
- SMALLFLOAT data type 2-64
- casts for 2-27
- syscolumns coltype code for 1-24
- SMALLINT data type 2-64
- casts for 2-27, 2-28
- length (syscolumns) 1-27
- syscolumns coltype code for 1-24
- Smart large object 2-17, Glossary-18
- attributes in syscolattribs 1-20
- Software dependencies Intro-5
- Sorting
- parallel process performance (PSORT_NPROCS) 3-61
- temporary dbspace for (DBSPACETEMP) 3-36
- temporary directory for (PSORT_DBTEMP) 3-60
- threads for (PSORT_NPROCS) 3-61
- Source file Glossary-18
- Space ( )
- as delimiter in DATETIME 2-42
- as delimiter in INTERVAL 2-50
- Specific name Glossary-18
- sysprocedures field 1-46
- SPL Glossary-18
- SPL function Glossary-18
- SPL procedure Glossary-18
- SPL routine Glossary-18
- SQL API Glossary-19
- SQL Communications Area (SQLCA)
- DBANSIWARN with 3-18
- SQL statements
- DBANSIWARN environment variable 3-18
- editor for (DBEDIT) 3-31
- print program for (DBPRINT) 3-34
- SQL3 Glossary-19
- sqlhosts file 3-51
- sql_languages Information Schema view 1-70
- Stacksize, setting INFORMIXSTACKSIZE 3-51
- state table in stores7 database, columns in A-7
- Statement Glossary-19
- block Glossary-19
- identifier Glossary-19
- Status variable Glossary-19
- stock table in stores7 database, columns in A-5
- Stored procedure Glossary-19
- Stored Procedure Language Glossary-19
- stores7 database Intro-6
- call_type table columns A-6
- catalog table columns A-5
- customer table columns A-2
- cust_calls table columns A-6
- data values A-16
- description of A-1
- items table columns A-4
- manufact table columns A-7
- map of A-8
- orders table columns A-3
- primary-foreign key relationships A-9 to A-16
- stock table columns A-5
- structure of tables A-2
- Strategy functions Glossary-19
- Subquery
- definition of Glossary-19
- Subtable Glossary-19
- Subtype Glossary-19
- Supertable Glossary-19
- Supertype Glossary-20
- Support functions Glossary-20
- Synonym
- syssynonyms information 1-51
- syssyntable information 1-52
- syscasts 2-25
- syscolattribs 1-20
- syscolauth
- example 1-8
- syscolumns 1-23
- example 1-7
- sysconstraints 1-29
- sysdefaults 1-30
- sysdepend 1-32
- sysdistrib 1-32
- syserrors 1-33
- sysfragauth 1-34
- sysfragments 1-36
- sysindexes
- view 1-39
- sysindices 1-37
- sysinherits 1-39
- syslangauth 1-40
- syslogmap 1-40
- Sysmaster databases Glossary-20
- sysobjstate 1-40
- sysopclasses 1-42
- sysprocauth 1-44
- sysprocedures 1-46
- sysprocplan 1-48
- sysreferences 1-49
- sysroleauth 1-50
- sysroutinelangs 1-51
- syssynonyms 1-51
- syssyntable 1-52
- systabauth 1-8, 1-53
- systables 1-54
- example 1-6
- System catalog 1-3 to 1-71
- accessing 1-10
- altering contents not recommended 1-10
- character variable length 1-27
- collection data type elements 1-17
- column information
- constraints (sysconstraints) 1-29
- default values (sysdefaults) 1-30
- complex data type members 1-17
- constraint information 1-20, 1-23
- data distribution information 1-32
- data type privileges 1-63
- database-level privileges 1-60
- description of Glossary-20
- execute on routine privileges 1-44
- how used by database server 1-5
- list of tables 1-11
- messages 1-33
- object states 1-40
- operator class table (sysopclasses) 1-42
- optical cluster 1-43
- privilege information
- user-defined data type 1-63
- privileges needed 1-10
- programming language 1-40
- programming languages supported 1-51
- referential constraint information 1-49
- referential constraints (sysreferences) 1-49
- role names for privileges 1-50
- routine plans 1-48
- routines 1-46
- smart large object attributes (syscolattribs) 1-20
- structure 1-11
- sysams 1-12
- sysattrtypes 1-17
- sysblobs table 1-18
- syscasts 1-19
- syschecks 1-20
- syscolauth 1-22
- syscoldepend 1-23
- sysindices 1-9
- sysopclstr 1-43
- sysprocbody 1-45
- sysviews 1-7
- sysxtddesc 1-62
- sysxtdtypeauth 1-63
- sysxtdtypes 1-64
- table fragment privileges 1-34
- table fragmentation 1-36
- table indexes 1-37
- table information
- dependencies (sysdepend) 1-32
- table inheritance 1-39
- table synonyms 1-51, 1-52
- table-level privileges 1-53
- tables in database 1-54
- trace classes 1-56
- trace messages 1-57
- triggers 1-59
- UPDATE STATISTICS for routines 1-48
- UPDATE STATISTICS results 1-32
- updating statistics 1-11
- updating tables 1-10
- user-defined casts 1-19
- user-defined data type descriptions 1-62
- view dependencies (sysdepend) 1-32
- view synonyms 1-52
- views 1-61
- violations 1-61
- System catalog routines
- systrigbody 1-58
- System indexes
- idxname
- used with sysindices 1-39
- idxtab
- used with sysindices 1-39
- System Monitoring Interface (SMI) Glossary-20
- System-defined cast
- definition of Glossary-20
- systraceclasses 1-56
- systracemsgs 1-57
- systracemsgs information 1-57
- systriggers 1-59
- sysusers 1-60
- sysviews 1-61
- sysviolations 1-61
- sysxtdtypes 2-56, 2-58
T
- tabid 1-54, 1-55
- Table
- definition of Glossary-20
- dependencies 1-32
- hierarchy Glossary-20
- inheritance Glossary-20
- privileges
- column-specific 1-22
- syscolauth sample entry 1-8
- systabauth information 1-53
- systabauth sample entry 1-8
- structure in stores7 database A-2
- sysdepend (dependencies) information 1-32
- systables information 1-54
- Table inheritance
- sysinherits information 1-39
- Table synonym
- syssyntabble information 1-52
- tables Information Schema view 1-67
- Tape management
- default remote shell (DBREMOTECMD) 3-35
- personal default qualifier for (ARC_DEFAULT) 3-16
- tctermcap file for(ARC_KEYPAD) 3-16
- Temporary table
- dbspaces for (DBSPACETEMP) 3-36
- directory location (DBTEMP) 3-38
- TERM environment variable 3-63
- TERMCAP environment variable 3-63
- Terminal handling
- DB-Access setup file (INFORMIXTERM) 3-52
- termcap file location (TERMCAP) 3-63
- terminal type (TERM) 3-63
- terminfo file location (TERMINFO) 3-64
- TERMINFO environment variable 3-64
- TEXT data type
- collation 2-66
- control characters with 2-65
- definition of Glossary-20
- inserting values 2-66
- Large object
- character 2-65
- length (syscolumns) 1-29
- selecting a column 2-66
- SQL restrictions 2-65
- sysblobs information 1-18
- syscolumns coltype code for 1-24
- Text editor, specifying with DBEDIT 3-26
- THREADLIB environment variable 3-65
- Time data type
- length (syscolumns) 1-28
- list of 2-9
- To 1-34
- Transaction Glossary-20
- Transaction logging Glossary-21
- Transaction mode Glossary-21
- Trigger
- definition of Glossary-21
- object mode (sysobjstate) 1-40
- systrigbody (linearized code) 1-58
- systriggers information 1-59
- Type
- inheritance Glossary-21
- substitutability Glossary-21
- Type constructor Glossary-21
- Type hierarchy Glossary-21
- Typed collection variable Glossary-21
- Typed table Glossary-21
- Types 2-9
U
- Unique
- constraint Glossary-21
- index Glossary-21
- Unique numeric code
- with SERIAL data type 2-59
- with SERIAL8 data type 2-61
- UNIX
- BSD, default print capability 3-34
- directories for intermediate writes 3-60
- environment variables 3-5
- PATH environment variable 3-58
- System V
- default print capability 3-34
- terminfo library support 3-52
- TERM environment variable 3-63
- TERMCAP environment variable 3-63
- TERMINFO environment variable 3-64
- Unnamed row type 2-67
- definition of Glossary-22
- Untyped collection variable Glossary-22
- UPDATE STATISTICS statement
- disk space for (DBUPSPACE) 3-41
- sysdistrib results from 1-32
- sysindices (index statistics) 1-39
- update system catalog 1-11
- User-defined data type
- definition of Glossary-22
- kinds of 2-20
- privileges
- sysxtdtypeauth 1-63
- sysxtddesc (extended type) information 1-62
- sysxtdtypes information about 1-64
- User-defined procedure
- definition of Glossary-22
- User-defined routine
- description of Glossary-22
- error messages (syserrors) 1-33
- privileges
- sysprocauth 1-44
- Utility program
- chkenv 3-10
V
- VARCHAR data type 2-69
- collation 2-70
- coltype code for 1-24
- length in syscolumns 1-27
- Variable
- definition of Glossary-22
- View
- dependencies 1-32
- description of Glossary-22
- sysdepend (dependencies) 1-32
- syssynonyms (synonym) 1-51
- syssyntable (synonym) 1-52
- sysviews information 1-61
- Violations table Glossary-23
- Violations tables
- sysviolations information 1-61
- Virtual column Glossary-23
- Virtual processor Glossary-23
- Virtual table Glossary-23
W
- Warning
- creating a new warning message 1-34
- White space Glossary-23
- Wildcard Glossary-23
X
- X/Open
- Information Schema views 1-65
- server_info view and 1-71
- X/Open compliance
- level Intro-16
- X/Open-compliant databases 1-71
Symbols
- ( ), space, as delimiter
- in DATETIME 2-42
- in INTERVAL 2-50
- -, hyphen, as delimiter
- in DATETIME 2-42
- in INTERVAL 2-50
- ., decimal point, as delimiter
- in INTERVAL 2-50
- /etc/termcap 3-64
- :, colon, as delimiter
- in DATETIME 2-42
- in INTERVAL 2-50
- \xfa , decimal point, as delimiter
- in DATETIME 2-42
|