SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-14
F
EXECUTE IMMEDIATE statement
C examples of 3-39
COBOL examples of 3-39
syntax diagram of 3-39
EXECUTE statement
C examples of 2-141
COBOL examples of 2-142
MXCI examples of 2-140
scope of 2-138, 2-140
syntax diagram of 2-137
EXISTS predicate
correlated subquery within 6-89
examples of 6-89
syntax diagram of 6-89
EXIT command
active transaction, effect on 4-28
examples of 2-147, 4-28
syntax diagram of 4-28
EXP function
examples of 9-54
syntax diagram of 9-54
EXPLAIN function
columns in result 9-56
examples of 9-59
operator tree 9-56
syntax diagram of 9-55
EXPLAIN statement
examples of 2-147
operators 2-145
OPTIONS ’m’ considerations 2-146
syntax diagram of 2-144
Expression
character (or string) value 6-38
datetime value 6-40, 6-42, 6-47
description of 6-38
interval value 6-42, 6-47
numeric value 6-49
Extensions
reserved words B-1
statements 1-33
EXTENT file attribute
limits C-1
MAXEXTENTS relationship 8-6
syntax diagram of 8-6
EXTRACT function
examples of 9-63
syntax diagram of 9-63
F
FASTCOPY 5-11
FASTCOPY INDEX command
syntax diagram of 5-12
FASTCOPY TABLE command
examples of 5-14
syntax diagram of 5-11
FC command
editing commands using 4-29
examples of 4-30
syntax diagram of 4-29
FETCH statement
C examples of 3-43
COBOL examples of 3-44
scope of 3-41
syntax diagram of 3-40
using host variables 3-41
FFDC_DIALOUTS_FOR_MXCMP
default 10-58
File attributes
summary of 8-1
ALTER INDEX use of 8-1
ALTER TABLE use of 8-1
AUDITCOMPRESS 8-3
BLOCKSIZE 8-4
CLEARONPURGE 8-5
CREATE INDEX use of 8-1
CREATE TABLE use of 8-1
description of 8-1
EXTENT 8-6
MAXEXTENTS 8-7