Download Informix Guide to SQL: Syntax, Version 6.0

DELETE keyword
syntax
in GRANT 1-235S
in REVOKE 1-301S
use
in GRANT 1-236S
in REVOKE 1-302S
Delete privilege 1-235S, 11-8T, 11-28T
DELETE REFERENCING clause
and FOR EACH ROW section 1-121S
correlation name 1-119S
syntax 1-119S
DELETE statement
all rows of table 4-4T
and end of data 6-14T
applied to view 11-24T
as triggering statement 1-112S
cascading 1-160S
coordinated deletes 6-6T
count of rows 6-4T
CURRENT OF clause 1-161S
description of 4-4T
embedded 5-6T, 6-3T to 6-8T
in trigger event 1-111S
in triggered action 1-122S
number of rows 5-12T
preparing 5-30T
privilege for 1-235S, 11-6T, 11-8T
syntax 1-159S
time to update indexes 10-20T
transactions with 6-5T
using subquery 4-6T
WHERE clause restricted 4-6T
with Condition segment 1-404S
with cursor 1-152S, 6-7T
with select..for update 1-340S
within a transaction 1-159S
Delete, cascading
See Cascading deletes
Delimiter
for DATETIME values 3-9R
for INTERVAL values 3-15R
for LOAD input file 1-258S
specifying with UNLOAD 1-380S
Delimiter form of FILE and INSERT
statements 5-24R
DELIMITER keyword
in LOAD 1-258S
in UNLOAD 1-380S
Demonstration database
copying Intro-10R, Intro-13S, 8T
installation script Intro-9R, Intro-12S,
7T
map of A-6R
overview Intro-9R, Intro-12S, 7T
structure of tables A-2R
tables in A-2R to A-6R
See also stores6 database.
Denormalizing 10-26T
Derived data
introduced for performance 10-30T
produced by view 11-20T
DESC keyword 1-338S
syntax
in CREATE INDEX 1-63S
in SELECT 1-337S
use
in CREATE INDEX 1-66S
in SELECT 1-338S
Descending order in SELECT 2-14T
DESCRIBE statement
and COLLCHAR environment
variable 4-46R
and the USING SQL DESCRIPTOR
clause 1-164S
describing statement type 1-163S,
5-33T
INTO sqlda pointer clause 1-165S
relation to GET DESCRIPTOR 1-213S
syntax 1-162S
using with concatenation operator
1-432S
values returned by SELECT 1-163S
Descriptor 1-164S
Determining ANSI-compliance 1-10R
Device
optical 12-6T
storage 12-6T
Directory, extension, .dbs 1-58S, 1-141S
Dirty Read isolation level 1-367S, 7-10T
DIRTY READ keywords, syntax in SET
ISOLATION 1-366S
DISCONNECT statement 1-169S
ALL keyword 1-169S
CURRENT keyword 1-168S
with
concatenation operator 1-432S
Disk access
chunk 10-4T
Index 15