Download Informix Guide to SQL: Syntax, Version 6.0

source of row values 1-285S
syntax 1-284S
use in transactions 1-285S
with concatenation operator 1-432S
with FLUSH 1-285S
Q
Qualifier, field
for DATETIME 3-8R, 1-428S, 1-488S
for INTERVAL 3-13R, 1-485S, 1-491S
Query
cyclic 4-22T
improving performance of 13-27T to
13-41T
performance of 13-3T to 13-42T
piping results to another program
1-272S
self-referencing 4-22T
sending results to an operating
system file 1-271S
sending results to another program
1-272S
stated in terms of data model 1-7T
time costs of 13-14T
Query optimization information
statements 1-6S
Query optimizer. See Optimizer.
Query plan
autoindex path 13-29T
chosen by optimizer 13-11T
description of 13-22T
display with SET EXPLAIN 13-12T
indexes in 13-26T
use in analyzing performance 13-29T
Question (?) mark
as placeholder in PREPARE 1-273S
naming variables in PUT 1-287S
replacing with USING keyword
1-268S
wildcard in Condition segment 1-411S
Quoted string
in expression 1-436S
syntax
in Condition segment 1-405S
in expression 1-462S
in INSERT 1-250S
use
in expression 1-438S
in INSERT 1-498S
with LIKE, MATCHES keywords
1-328S
See also Quoted String segment.
Quoted String segment
DATETIME, INTERVAL values as
strings 1-498S
syntax 1-497S
wildcards 1-498S
with LIKE in a condition 1-498S
Quotes, single and double Intro-6S
R
RAISE EXCEPTION statement
exiting a loop 14-23T
syntax 2-36S
REAL data type. See SMALLFLOAT data
type.
RECOVER TABLE statement
archiving a database with audit trails
1-292S
manipulating audit trail file 1-293S
syntax 1-292S
Recursion, in a stored procedure 14-24T
Recursive relationship 8-11T, 8-28T
Redundant data, introduced for
performance 10-31T
Redundant relationship 8-29T
REFERENCES FOR keywords, in INFO
statement 1-243S
REFERENCES keyword
in ALTER TABLE 1-21S
in CREATE TABLE 1-94S, 1-96S
syntax
in GRANT 1-235S
in REVOKE 1-301S
use
in GRANT 1-236S
in REVOKE 1-302S
References privilege
definition of 1-236S
displaying with the INFO statement
1-243S
REFERENCING clause
DELETE REFERENCING clause
1-119S
INSERT REFERENCING clause
1-118S
UPDATE REFERENCING clause
1-120S
Index 35