Download Informix Guide to SQL: Syntax, Version 6.0

rolling back 1-4R, 1-306S
scroll cursor and data consistency
1-369S
starting with BEGIN WORK 1-35S
stopping logging 1-376S
transaction log 4-24T, 4-26T
transaction log required 9-22T
use signalled in SQLAWARN 5-12T
using cursors in 1-155S
Transaction logging
ANSI-compliant database, effects
1-12R
buffered 9-22T
effect on database server type 1-5R
establishing with CREATE
DATABASE 9-21T
OnLine methods of 9-22T
renaming log 1-377S
stopping 1-377S
turning off for faster loading 9-28T
turning off not possible 9-24T
Transaction log, contents of 4-25T
Transaction manager 12-11T
Transfer of database files 5-19R
Transitive dependency 8-32T
Trigger
creating 15-4T
definition of 15-3T
in client/server environment 1-133S
number on a table 1-112S
preventing overriding 1-132S
when to use 15-3T
Trigger event
definition of 1-111S, 15-5T
example of 15-5T
in CREATE TRIGGER statement
1-111S
INSERT 1-119S
privileges on 1-113S
with cursor statement 1-112S
Trigger name
assigning 15-5T
syntax 1-113S
Triggered action
action on triggering table 1-127S
anyone can use 1-129S
BEFORE and AFTER 15-7T
cascading 1-118S
clause 1-121S
action statements 1-122S
46 Index
syntax 1-121S
WHEN condition 1-121S
correlation name in 1-125S, 1-128S
FOR EACH ROW 15-8T
generating an error message 15-14T
in client/server environment 1-133S
in relation to triggering statement
15-6T
list
AFTER 1-117S
BEFORE 1-116S
FOR EACH ROW 1-116S
for multiple triggers 1-117S
sequence of 1-116S
merged 1-117S
preventing overriding 1-132S
statements 15-3T
tracing 15-12T
using 15-7T
using stored procedures 15-10T
WHEN condition 1-121S, 15-10T
Triggering statement
affecting multiple rows 1-117S
execution of 1-113S
guaranteeing same result 1-112S
result of 1-123S
UPDATE 1-115S
Triggering table
action on 1-127S
and cascading triggers 1-131S
Trigonometric function
ACOS function 1-460S
ASIN function 1-460S
ATAN function 1-460S
ATAN2 function 1-461S
COS function 1-459S
SIN function 1-459S
TAN function 1-460S
TRUNC function
syntax in expression 1-444S
use in expression 1-447S
Truncation, signalled in SQLAWARN
5-12T
Two-phase commit 12-20T
TYPE field
changing from BYTE or TEXT 1-359S
setting in SET DESCRIPTOR 1-356S
setting in X/Open programs 1-357S
with X/Open programs 1-213S