Index

A

Access

restricting to columns or rows 11-23

restricting to view 11-32

restricting with SPL routine 11-19

Access mode 7-17

Active set

cursor 5-24 to 5-27

Aggregate function

and GROUP BY clause 3-5

in ESQL 5-14

in subquery 3-32

restrictions in modifiable view 11-29

Alias

SELECT...FROM with 2-74

table name replacement 2-74

to assign column names in temporary table 3-13

typed table with 12-6

use before define 2-74

ALTER FRAGMENT statement

example 9-49

INIT clause 9-50, 9-53

ALTER TABLE statement

ADD ROWIDS clause 9-53

DROP ROWIDS clause 9-53

ANSI 1-16

ANSI compliance

Informix SQL solution 1-16

level Intro-13

ANSI-compliant database

FOR UPDATE not required in 6-16

logging restrictions 9-40

SQLWARN flag 5-12

table privileges 11-8

Application

design of order-entry 4-27

handling errors 5-17

Archiving

description of 1-9, 4-31

Arithmetic operator

SELECT with 2-45

Attribute

identifying 8-17

important qualities of 8-17

nondecomposable 8-17

B

Bachman, C. R. 8-19

BEGIN WORK statement

specifies start of a transaction 4-30

BLOB data type 9-26

displaying values 2-10

restrictions

with GROUP BY 3-6

SQL restrictions 9-26

blobspace 9-32

BOOLEAN data type 9-19

Building your data model 8-3 to 8-36

Built-in data type 9-5 to 9-33

BYTE data type 9-31

displaying values 2-10

LENGTH function 2-60

restrictions

with GROUP BY 3-6

SQL interactively with 9-32

SQL restrictions 9-32

C

Candidate key 8-26

Cardinality 8-11

in relationship 8-15

CARDINALITY function 12-18

Cartesian product 2-66

refining 2-67

Cascading deletes 4-23

restrictions 4-24

Cast 13-3 to 13-23

CAST AS keywords 13-4

collection data type 13-13 to 13-16

collection elements 13-16

distinct data type 13-5, 13-17

explicit 13-4

invoking 13-4

implicit 13-4

invoking 13-5, 13-6

named row type 13-5, 13-12

operator for explicit cast 13-4

row type 13-6 to 13-13

single-level vs. multilevel 13-22

system-defined 13-4

types of 13-4

unnamed row type fields 13-12

user-defined 13-20 to 13-22

creating 13-5

CHAR data type 9-20

Character data type 9-20 to 9-24

execution time 9-23

subscripting 2-43

substring notation 2-26

varying length 9-22

CHARACTER VARYING data type 9-22

Check constraint 4-20, 9-34

Class libraries, shared 1-10

CLOB data type 9-25

displaying values 2-10

restrictions

with GROUP BY 3-6

SQL restrictions 9-26

CLOSE DATABASE statement

effect on database locks 7-8

COBOL 5-6

Codd, E. F. 1-10, 8-35

Collation order

ascending and descending 2-13

non-English data 2-24

Collection data type 10-14 to 10-20

accessing 12-14

casting 13-13 to 13-16

examples 13-15

requirements 13-16

counting elements in 12-18

creating a domain for 9-35

element

searching for with IN 12-16

element type 10-14

nesting 10-19

simple 12-14

type checking 13-14

type constructor 10-14

Collection variable

nested 12-14

selecting 12-16

Column

check constraint 4-20, 9-34

constraint properties 8-24

constraints 4-20

data type 4-20

default value 4-20, 9-34

defining 8-23

multiple attributes in 10-10, 10-13

label on 3-43

number 2-22

order listed from SELECT 2-12

privileges 11-10

properties 4-20, 9-3

relational and object-relational model 1-12

Command script file

creating database 9-42

Comment icons Intro-10

COMMIT WORK statement

closing cursors 7-23

releasing locks 7-10, 7-23

setting SQLCODE 6-5

Committed Read

isolation level (Informix) 7-14

Complex data type 9-4, 10-4 to 10-39

using 10-5

Complex relationship 8-30

Compliance, with industry standards Intro-13

Composite key 8-26

Compound query 3-39

Concurrency

access modes 7-17

ANSI Read Committed isolation 7-14

ANSI Read Uncommitted isolation 7-13

ANSI Repeatable Read isolation 7-16

ANSI Serializable isolation 7-16

database lock 7-8

deadlock 7-19

description of 4-32, 7-3

effect on performance 7-3

Informix Cursor Stability isolation 7-14

Informix Dirty Read isolation 7-13

Informix Read Committed isolation 7-14

Informix Repeatable Read isolation 7-16

isolation level 7-11

lock duration 7-10

lock scope 7-7

lock types 7-7

SERIAL and SERIAL8 values 9-10

Condition

BETWEEN operator 2-31

boolean 2-35

comparison 2-27 to 2-44

ESCAPE character substitution 2-43

range of values 2-43

special characters 2-43

compound 2-35

LIKE comparator

wildcards 2-36

MATCHES comparator

wildcards 2-36

NOT operator 2-31

subscript delimiters 2-43

Connectivity in relationship 8-10, 8-13, 8-20

Constant

inserting rows of 6-12

Constraint

cardinality 8-11

column-level 8-24

disabled 4-26

enabled 4-26

enforcing 11-31

Constraints

enforcing 11-23

Coordinated deletes 6-6

COUNT function

and GROUP BY 3-6

count rows to delete 4-5

DISTINCT keyword with 2-51

use in a subquery 4-6

CREATE DATABASE statement 9-38

in command script 9-42

sets shared lock 7-8

SQLWARN flags 5-12

CREATE DOMAIN statement

using 9-35

CREATE FUNCTION statement

cast registration examples 13-21

WITH LISTING IN clause 14-80

CREATE PROCEDURE statement

WITH LISTING IN clause 14-80

CREATE TABLE statement

description of 9-40

in command script 9-42

WITH ROWIDS clause 9-53

CREATE VIEW statement

WITH CHECK OPTION

keywords 11-31

Cursor

active set 5-24 to 5-27

closing 7-23

declaring 5-21

example

parts explosion 5-27

fetching values 5-22

opening 5-21

scroll 5-23

Cursor routine 14-30

Cursor Stability isolation level (Informix) 7-14

D

Data

accessing in fragmented tables 9-52

Data definition language statements 5-34

Data integrity 4-19, 4-27 to 4-30

Data model

attribute 8-17

building 8-3 to 8-36

defining relationships 8-9

description of 1-3, 8-3

entity relationship 8-5

many-to-many relationship 8-13

one-to-many relationship 8-13

one-to-one relationship 8-13

telephone-directory example 8-7

Data type

automatic conversions 5-16

changing with ALTER TABLE 9-33

character 9-20 to 9-24

choosing 9-5 to 9-8

referential constraint considerations 9-6

chronological 9-15 to 9-19

conversion 4-9

date and time 9-15

duration interval 9-17

execution time 9-23

fixed-point 9-13

floating-point 9-12

for code 9-9

for counter 9-9

numeric 9-9 to 9-15

varying length 9-22 to 9-24

Database

ANSI-compliant 1-17

archiving 1-9

concurrent use 1-8

GLS 1-17

management of 1-8

mission-critical 1-9

naming unique to database server 9-38

object-relational, description of 1-10

populating new tables 9-43

script for creating 9-42

server 1-8

Database administrator (DBA) 11-7

Database lock 7-8

Database object

constraints as a 4-25

index as a 4-25

object modes 4-25

trigger as a 4-25

violation detection 4-25

Database server

archiving 4-31

DATABASE statement

exclusive mode 7-8

locking 7-8

SQLWARN after 5-12

DataBlade modules 1-10

DATE data type 9-15

international date formats 1-17

ORDER BY sequence 2-13

DATE function 2-58

DATETIME data type 9-16

DATE function with 2-58

EXTEND function with 2-58

format 9-18

format for 2-58

international formats 9-19

ORDER BY sequence with 2-13

DB-Access

creating database with 5-34, 9-42

Modify option 14-80

syntax error 14-80

UNLOAD statement 9-44

dbaccessdemo7 script Intro-7

DBDATE environment variable 4-9, 9-16

DBMONEY environment variable 9-15

dbschema utility 9-42

DBSERVERNAME function

example 3-19

dbspace

ALTER FRAGMENT to add 9-50

CREATE DATABASE with 9-39

DBTIME environment variable 9-19

Deadlock detection 7-19

DECIMAL data type

fixed-point 9-13

floating-point 9-12

DECLARE statement

CURSOR FOR keyword 5-21

FOR INSERT clause 6-9

FOR UPDATE 6-15

SCROLL keyword 5-24

WITH HOLD clause 7-24

Default locale Intro-6

Default value 9-34

Delete privilege 11-8

DELETE statement

all rows of table 4-4

coordinated deletes 6-6

count of rows 6-4

description of 4-4

embedded 5-6, 6-3 to 6-8

number of rows 5-10

preparing 5-31

privilege for 11-5, 11-8

transactions with 6-5

using subquery 4-6

view with 11-29

WHERE clause restricted 4-7

with cursor 6-7

Demonstration database Intro-7

DESCRIBE statement

describing statement type 5-33

Descriptor column 8-25

Dirty Read isolation level (Informix) 7-13

Disabled object mode

defined 4-25

Display label

derived SELECT data 2-48

in ORDER BY clause 2-50

Distinct data type

cast for 13-5

casting 13-17

DISTINCT keyword

relation to GROUP BY 3-4

restrictions in modifiable view 11-29

Distributed deadlock 7-20

Documentation conventions

icon Intro-10

sample-code Intro-11

typographical Intro-9

Documentation notes Intro-13

Documentation, types of

documentation notes Intro-13

error message files Intro-12

machine notes Intro-13

on-line manuals Intro-11

printed manuals Intro-12

release notes Intro-13

Domain

definition of 9-35

Dominant table 3-20

Dot notation 12-9

DROP CAST statement

changing cast for distinct data type 13-19

Duplicate values

finding 3-15

Dynamic routine-name specification

of SPL functions 14-72

of SPL procedures 14-72

rules for 14-74

Dynamic SQL

description of 5-5, 5-29

freeing prepared statements 5-33

E

Element 10-14

Element type 10-14

Embedded SQL

defined 5-4

languages available 5-4

Enabled object mode

defined 4-25

End of data

signal in SQLCODE 5-9, 5-18

when opening cursor 5-21

Entity

attributes associated with 8-17

business rules 8-5

criteria for choosing 8-8

defined 8-5

important qualities of 8-6

in telephone-directory example 8-9

naming 8-5

occurrence of 8-18

Entity integrity 4-19

Entity-relationship diagram

connectivity 8-20

discussed 8-19

meaning of symbols 8-19

reading 8-20

Environment variable

CLIENT_LOCALE 2-24

DB_LOCALE 2-24

en_us.8859-1 locale Intro-6

Equi-join 2-68

Error checking

simulating errors 14-87

SPL routine 14-84 to 14-88

Error message files Intro-12

Error message variable 5-13

Error messages

retrieving trigger text in a program 15-15, 15-17

trigger failure 15-14

Errors

after DELETE 6-4

codes for 5-10

dealing with 5-17

detected on opening cursor 5-21

during updates 4-27

inserting with a cursor 6-11

ISAM error code 5-10

ESQL

DELETE statement in 6-3

delimiting host variables 5-6

dynamic embedding 5-5, 5-29

error handling 5-17

host variable 5-6, 5-8

indicator variable 5-16

INSERT in 6-9

overview 5-3 to 5-37, 6-3 to 6-18

preprocessor 5-4

selecting single rows 5-14

SQL Communications Area 5-8

SQLCODE 5-9

SQLERRD fields 5-10

static embedding 5-5

UPDATE in 6-15

EXECUTE IMMEDIATE statement

description of 5-34

Execute privilege

DBA keyword, effect of 14-78

objects referenced by a routine 14-78

EXECUTE statement

description of 5-32

Execution time

varying length data types influences 9-23

Existence dependency 8-10

EXISTS keyword

in a WHERE clause 3-30

Expression

cast allowed in 13-3

display label for 2-48

EXTEND function 2-58

Extended data types 9-4

Extensibility

description of 1-10

F

Feature icons Intro-10

Features, product Intro-7

FETCH statement 5-22

ABSOLUTE keyword 5-24

INTO clause location 5-23

Field 10-5

Field projection 12-9

File

compared to database 1-3

Filtering object mode

defined 4-25

First normal form 8-32

Fixed-point data types 9-13

FLOAT data type 9-11

Floating-point data types 9-12

FLUSH statement

count of rows inserted 6-11

writing rows to buffer 6-10

Foreign key 4-21, 8-27

Fragmentation 9-45 to 9-55

accessing table data 9-52

initializing 9-50

modifying 9-49

rowid column 9-53

FREE statement

freeing prepared statements 5-33

Function

SELECT with 2-50

Functional dependency 8-33

G

Global Language Support (GLS) Intro-6

collation (sort) order 2-24

database, description of 1-17

DATETIME format 9-19

default locale 2-24

MATCHES with 2-41

SELECT...ORDER BY with 2-24

global variable

defined 14-24

GL_DATETIME environment variable 9-19

GRANT FRAGMENT statement 9-54

GRANT statement

database-level privileges 11-5

in embedded SQL 5-35 to 5-37

table-level privileges 11-7

GROUP BY keywords

column number with 3-7

description of 3-4

restrictions in modifiable view 11-29

H

HAVING keyword

description of 3-9

Hold cursor 7-23

Host variable

delimiter for 5-6

description of 5-6

dynamic allocation of 5-33

fetching data into 5-22

in DELETE statement 6-4

in INSERT 6-9

in UPDATE 6-15

in WHERE clause 5-15

INTO keyword sets 5-14

null indicator 5-16

restrictions in prepared statement 5-30

with EXECUTE 5-32

I

Icons

comment Intro-10

feature Intro-10

IN relational operator 3-30

Index

disabled mode 4-26

enabled mode 4-26

filtering mode 4-26

fragmentation with 9-45

table locks 7-8

Indicator variable

definition of 5-16

Industry standards, compliance with Intro-13

INFORMIX-4GL

detecting null value 5-17

indicator variable not used 5-17

program variable 5-6

STATUS variable 5-9

terminates on errors 5-37, 6-14

using SQLCODE with 5-9

WHENEVER ERROR statement 5-36

INFORMIXDIR/bin directory Intro-7

INFORMIX-SQL

creating database with 5-34, 9-42

UNLOAD statement 9-43

INFORMIX-Universal Server

characteristics of 1-9

Inheritance 10-20 to 10-38

single 10-20

type hierarchy 10-20

type substitutability 10-25

Insert cursor 6-9

constants with 6-12

definition of 6-9

Insert privilege 11-8

INSERT statement 4-7

constant data with 6-12

count of rows inserted 6-11

duplicate values in 4-8

embedded 6-9 to 6-14

multiple rows 4-10

null values in 4-8

number of rows 5-10

privilege for 11-5, 11-8

SELECT statement with 4-10

VALUES clause 4-7

view with 11-30

Instance 1-13

example 10-8

INT8 data type 9-9

INTEGER data type 9-9

Interrupted modifications 4-27

INTERVAL data type 9-17

format 9-18

INTO keyword

restrictions in prepared statement 5-30

retrieving single rows 5-14

INTO TEMP keywords

description of 2-76

ISAM error code 5-10

ISO 8859-1 code set Intro-6, 2-24

Isolation level

ANSI Read Committed 7-14

ANSI Read Uncommitted 7-13

ANSI Repeatable Read 7-16

ANSI Serializable 7-16

description of 7-11

Informix Committed Read 7-14

Informix Cursor Stability 7-14

Informix Dirty Read 7-13

Informix Repeatable Read 7-16

setting 7-11

J

Join 2-8

associative property of 2-70

creating 2-67

creating with SELECT...WHERE 2-67

dominant and subservient table 3-20

equality (equi-join) 2-68

equi-join 2-68

foreign keys in 8-27

illustrated 2-8

multiple-table 2-71

multiple-table join 2-71

natural 2-69

nested outer 3-25

nested simple 3-23

outer 3-20

restrictions in modifiable view 11-29

self-join 3-11

simple 3-21

storing results 3-13

K

Key

composite 8-26

foreign 8-27

primary 8-25

Key column 8-25

Key lock 7-10

L

Label 2-48, 3-43

Large object 9-24 to 9-32

LENGTH function 2-60

LET statement 14-26

LIST 10-18

local variable

defined 14-15

Locale Intro-6, 1-17

Lock

database 7-8

exclusive 7-7, 7-10

granularity 7-7

key 7-9

page 7-9

promotable 7-7, 7-10

row 7-9

scope of 7-7

shared lock 7-7

table

explicit 7-9

implicit 7-8

Lock mode

setting 7-9

LOCK TABLE statement 7-9

Locking

and concurrency 4-32

and integrity 7-3

deadlock 7-19

DELETE statement with 6-4

description of 7-6

lock duration 7-10

lock mode 7-18

not wait 7-18

wait 7-18

locks released at end of transaction 7-23

modifying data with 7-10

setting lock mode 7-18

types of locks

database lock 7-8

Logging

buffered 9-40

types of 9-39

unbuffered 9-39

Logical log 4-31

Loop

exiting with RAISE exception 14-88

LVARCHAR data type 9-22

M

Machine notes Intro-13

Major features Intro-7

Mandatory entity in relationship 8-10

Many-to-many relationship 8-10, 8-13, 8-29

MONEY data type 9-13

display format 9-15

INSERT statement with 4-9

international money formats 1-17, 9-15

MONTH function 2-55

MULTISET 10-17

N

Named row type 10-5 to 10-12

casting 13-5

column of 10-10

creating a typed table with 10-8

dropping 10-12

example 10-5

naming conventions 10-7

restrictions on 10-7

when to use 10-6

Natural join 2-69

NCHAR data type 9-21

collation order 2-24

querying on 2-10

Nested

collection 10-19

NODFDAC

effect on privileges granted to public 14-76

Nondecomposable attributes 8-17

Normal form 8-31

Normalization

benefits 8-31

first normal form 8-32

of data model 8-31

rules 8-31

rules, summary 8-35

second normal form 8-33

third normal form 8-34

NOT NULL keywords

use in CREATE TABLE 9-40

NOT relational operator 2-31

NULL relational operator 2-34

Null value 9-33

detecting in ESQL 5-16

inserting 4-8

restrictions in primary key 8-25

testing for 2-34

Numeric data types 9-9 to 9-15

NVARCHAR data type

collation order 2-24

querying on 2-10

O

Object-relational database, description of 1-10

Object-relational model

description of 1-10

ON EXCEPTION statement

scope of control 14-85

trapping errors 14-84

user-generated errors 14-87

One-to-many relationship 8-10, 8-13

One-to-one relationship 8-10, 8-13

On-line manuals Intro-11

onload utility 4-31

onunload utility 4-31, 9-44

Opaque data type 9-4

cast for 13-5

OPEN statement

activating a cursor 5-21

opening select or update cursors 5-21

Optional entity in relationship 8-10

OR logical operator 2-32

ORDER BY keywords

relation to GROUP BY 3-7

restrictions with FOR UPDATE 6-8

Ownership 11-7

P

Page lock

effect on index 7-10

Performance

buffered log 9-40

depends on concurrency 7-3

Populating tables 9-43

Precedence

dot notation 12-9

PREPARE statement

description of 5-31

error return in SQLERRD 5-10

multiple SQL statements 5-31

Primary key

definition of 8-25

restrictions with 8-25

Primary key constraint 4-21

Printed manuals Intro-12

Privilege 11-5 to 11-18

column-specific 11-10

database-level 4-16

DBA 11-7

encoded in system catalog 11-9

Execute 11-14

fragment 9-54

granting 11-5 to 11-15

Insert 11-8

overview 1-8

public 4-17

Resource 11-6

Select 11-8, 11-10

table-level 4-17, 11-8 to 11-12

column-specific 11-10

in ANSI-compliant database 11-8

making column-specific 11-10

systabauth information 4-18

Update 11-8

view 11-32

Projection 1-14, 2-7

Promotable lock 7-10

PUBLIC keyword

privilege granted to all users 11-6

PUT statement

constant data with 6-12

count of rows inserted 6-11

sends returned data to buffer 6-10

Q

Query

alias with 2-74

examples 2-6 to 2-79

stated in terms of data model 1-6

variable text 2-36

R

RAISE EXCEPTION statement 14-84

Rational operator

list of 2-28

Read Committed isolation level (ANSI) 7-14

Read Uncommitted isolation level (ANSI) 7-13

Recursive relationship 8-12, 8-30

Redundant relationship 8-31

Referential constraint

data type considerations 9-6

Referential integrity 4-19, 4-21

defining primary and foreign keys 8-27

Relational model

attribute 8-17

description of 8-3 to 8-36

entity 8-5

join 2-8

many-to-many relationship 8-13

normalizing data 8-31

one-to-many relationship 8-13

one-to-one relationship 8-13

projection 2-7

resolving relationships 8-29

rules for defining tables, rows, and columns 8-23

selection 2-6

Relational operation 2-6

Relational operator

BETWEEN 2-31

equals 2-29

EXISTS 3-30

IN 3-30

NOT 2-31

NULL 2-34

OR 2-32

WHERE clause with 2-28

Relationship

attribute 8-17

cardinality 8-11, 8-15

complex 8-30

connectivity 8-10, 8-13

defining in data model 8-9

entity 8-6

existence dependency 8-10

mandatory 8-10

many-to-many 8-10, 8-13

many-to-many, resolving 8-29

one-to-many 8-10, 8-13

one-to-one 8-10, 8-13

optional 8-10

recursive 8-30

redundant 8-31

using matrix to discover 8-11

Release notes Intro-13

Repeatable Read isolation level 7-16

Resource privilege 11-6

REVOKE FRAGMENT statement 9-55

REVOKE statement

in embedded SQL 5-35 to 5-37

Role

enabling with SET ROLE 11-18

granting privileges with GRANT 11-17

naming restrictions 11-16

sysroleauth system catalog table 11-18

sysusers system catalog table 11-18

using 11-16

ROLLBACK WORK statement

closes cursors 7-23

releases locks 7-10, 7-23

sets SQLCODE 6-5

Routine

security purposes 11-3

Routine overloading 10-24

Routine resolution 10-26

Row

checking rows processed in SPL routines 14-89

defining 8-23

deleting 4-4

cascading to child rows 4-23

in relational model 8-23

inserting 4-7

inserting multiple 4-10

instance of entity 1-13

object-relational model 1-13

sorting with SELECT...ORDER BY 2-12

Row type

accessing 12-4

casting 13-6 to 13-13

casting individual field 13-13

dot notation with 12-9

field projection 12-9

nested 10-12, 12-10

selecting columns of 12-7

Rowid

fragmented tables and 9-52

join using 3-15

locating internal row numbers 3-17

S

Sample-code conventions Intro-11

sbspace 9-26

defaults, overriding with extent 9-29

Scroll cursor

active set 5-26

Second normal form 8-33

Security

database-level privileges 11-4

making database inaccessible 11-4

restricting access to rows 11-25

table-level privileges 11-10

with routines 11-3

Select cursor

opening 5-21

use of 5-21

Select list 2-17

explicit 2-12

implicit 2-13

labels in 3-43

substring notation 2-26

Select privilege

column level 11-10

definition of 11-8

SELECT statement 2-10 to 2-79

active set 2-28

alias names 2-74

alias with 2-74

column list

display label 2-48

compound query 3-39

correlated subquery 3-29

cursor for 5-21

deriving data from expressions 2-45

description of advanced 3-4 to 3-49

display label 2-48

DISTINCT keyword 2-51

embedded 5-14

end of data indicator 6-14

functions in 2-50 to 2-63

GROUP BY clause 3-4

HAVING clause 3-9

INSERT with 4-10

INTO TEMP clause 2-76

join 2-67 to 2-73

multiple-table 2-66

ORDER BY clause 2-12

display label with 2-50

sorting rows 2-12

outer join 3-20 to 3-28

privilege for 11-5, 11-8

rowid 3-15, 3-20

search criteria 2-28

singleton 2-28

SPL routines in 2-64

SQLCODE, SQLSTATE with 6-14

subquery 3-29 to 3-38

subquery (inner SELECT) 3-29

UNION operator 3-39

view with 11-29

WHERE clause 2-27 to 2-44

* (asterisk) with 2-11

Selection 1-13, 2-6

Self-referencing query 3-11

Semantic integrity 4-19, 4-20, 9-3

Sequential cursor 5-23

active set 5-25

SERIAL data type 9-10

generated number in SQLERRD 5-10

initializing value 9-10

starting value 4-9

SERIAL8 data type 9-10

initializing value 9-10

Serializable isolation level (ANSI) 7-16

SET 10-16

Set difference 3-47

Set intersection 3-46

SET ISOLATION statement

controlling the effect of locks 4-32

discussed 7-11

similarities to SET TRANSACTION statement 7-12

SET LOCK MODE statement

controlling the effect of locks 4-32

description of 7-18

SET LOG statement

buffered vs. unbuffered 9-40

SET TRANSACTION statement

access mode 7-17

similarities to SET ISOLATION statement 7-12

Shared class libraries 1-10

Simple large object 9-24, 9-30 to 9-32

blobspace storage for 9-32

SQL interactively with 9-32

SQL restrictions 9-32

Single inheritance 10-20

Singleton SELECT statement 2-28

SITENAME function

example 3-19

SMALLFLOAT data type 9-11

SMALLINT data type 9-9

Smart large object 9-24, 9-25 to 9-30

column defaults inherited 9-29

extent size 9-29

functions for copying 9-27

importing and exporting 9-27

sbspace storage for 9-26

SQL interactive uses 9-27

SQL restrictions 9-26

Software dependencies Intro-6

Sorting

column by number in SELECT 2-23

nested 2-14

non-English data 2-24

with ORDER BY 2-13

Sorting rows 2-12

SPL

program variable 5-6

SPL function

dynamic routine-name specification 14-72

SPL procedure

dynamic routine-name specification 14-72

SPL routine

as triggered action 15-11

automating access control 11-19

compiler warning 14-80

cursor routine 14-30

debugging 14-82

exceptions 14-84 to 14-88

finding in system catalog 14-81

FOREACH loop 14-30

listing compiler messages 14-80

SELECT statement with 2-64

syntax error 14-80

tracing triggered actions 15-13

SQL

error handling 5-17

history 1-15

Informix 1-16

Structured Query Language 1-15

SQL Communications Area (SQLCA)

altered by end of transaction 6-5

description of 5-8

inserting rows 6-11

SQL statements

ANSI-compliant with Informix extensions 1-16

SQLCODE field

after opening cursor 5-21

description of 5-9

end of data on SELECT 6-14

end of data signalled 5-18

set by DELETE 6-4

set by DESCRIBE 5-33

set by PUT, FLUSH 6-11

SQLERRD array

count of deleted rows 6-4

count of inserted rows 6-11

count of row 6-14

description of 5-10

syntax of naming 5-8

SQLERRM character array 5-13

SQLSTATE variable

in databases that are not ANSI compliant 5-18

use with a cursor 5-22

SQLWARN array 5-12

syntax of naming 5-8

with PREPARE 5-31

Static SQL 5-5

STATUS variable (4GL) 5-9

Stored procedure

name confusion with SQL functions 14-24

Stored routine

granting privileges on 11-14

stores7 database Intro-7

Subquery

collection column and 12-14

correlated 3-29

cascading deletes error 4-24

correlated vs. uncorrelated 3-29, 4-14

in DELETE statement 4-6

in SELECT 3-29 to 3-38

UPDATE with 4-13

Subscripting

SPL variables 14-22

Subservient table 3-20

Substitutability 10-25

Substring 14-22

Subtable 10-20

Subtype 10-20

Supertable 10-20

Supertype 10-20

systabauth 4-18

systables 4-18

System catalog

privileges in 11-9

syscolauth 11-9

sysprocbody 14-81

systabauth 11-9

sysusers 11-9

T

Table

creating with CREATE TABLE 9-40

dependencies 4-21

descriptor column 8-25

fragmenting 9-45

in object-relational model 1-11

in relational model 8-23

join 4-21

key column 8-25

object-relational model 1-11

operations on 1-13

ownership 11-7

primary key 8-25

privileges 11-8 to 11-12

represents an entity 8-25

untyped 10-8

Temporary table

assigning column names 3-13

creating with SELECT 2-76

cursor active set with 5-25

example 4-12

TEXT data type 9-30

displaying values 2-10

restrictions

with GROUP BY 3-6

SQL interactively with 9-32

SQL restrictions 9-32

with LENGTH function 2-60

Third normal form 8-34

Time function

SELECT with 2-53

TODAY function

constant expression with 4-9

TRACE statement

debugging an SPL routine 14-82

output 15-13

Transaction

boundaries 4-30

cursors in 7-23

data integrity protection 4-28

example 6-5

locks with 7-10, 7-23

MODE ANSI with 4-30

SQLWARN flag 5-12

Transaction logging 4-29

buffered 9-40

contents of log 4-31

establishing with CREATE DATABASE 9-38

turning off for faster loading 9-44

unbuffered 9-39

Transitive dependency 8-34

Trigger

actions

BEFORE and AFTER 15-7

statements allowed 15-3

tracing 15-13

WHEN 15-10

creating 15-4

definition of 15-3

disabled mode 4-26

enabled mode 4-26

event 15-5

name 15-5

SPL routines with 15-11

using 15-7 to 15-12

when to use 15-3

Triggered action 15-6

error message 15-14

FOR EACH ROW 15-9

Type constructor 10-14

Type hierarchy 10-20

Type substitutability 10-25

Typed table 10-8

alias, creating 12-6

modifying rows of 12-10

U

UNION operator

description of 3-39

display labels with 3-43

UNIQUE keyword

constraint in CREATE TABLE 9-40

restrictions in modifiable view 11-29

UNLOAD statement

exporting data to a file 9-43

Unnamed row type 10-13 to 10-14

restrictions on 10-14

Untyped table

converting to a typed table 10-9

Update cursor 6-15, 7-10

definition of 6-15

Update privilege

column level 11-10

definition of 11-8

UPDATE statement 4-13 to 4-16

description of 4-13

embedded 6-15 to 6-17

number of rows 5-10

preparing 5-31

privilege for 11-5, 11-8

SET clause 4-13, 4-15

subquery restrictions 4-15

view with 11-29

USER function 2-60

examples 3-18

User-defined cast

casting between data types 13-16

User-defined data type

cast for 13-5

Utility program

dbload 9-44

dbschema 9-42

onload 4-31

onunload 4-31

onunload utility 9-44

V

VARCHAR data type 9-22

displaying values 2-10

LENGTH function 2-60

Variable

with same name as a keyword 14-22

Varying length data type

execution time 9-23

View 11-23 to 11-32

changes to base table 11-26

constraints with 11-31

creating 11-24

derived data 11-24

dropped when basis is dropped 11-26

duplicate rows 11-25, 11-30

external table and 11-27

inserting rows in 11-30

modifying data through 11-29

restrictions on 11-26

typed 11-27

using CHECK OPTION 11-31

W

WEEKDAY function 2-56

WHERE clause

host variables in 5-15

WHERE CURRENT OF keywords

use

in DELETE 6-7

in UPDATE 6-15

WHERE keyword

in DELETE 4-4 to 4-7

subqueries in 3-30

WITH CHECK OPTION keywords, of CREATE VIEW statement 11-31

WITH HOLD keywords

declaring a hold cursor 7-24

X

X/Open compliance

level Intro-13

Symbols

*, asterisk

wildcard character in SELECT 2-11

::, cast operator 13-4

=, equal sign, relational operator

including rows with 2-29

joining tables with 2-68

?, question mark

placeholder in PREPARE 5-30

[...], square brackets

range delimiters in condition 2-43