SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-14
F
Exclamation point (!) command
examples of 4-28
syntax diagram of 4-28
EXCLUSIVE lock mode 1-11
EXEC SQL directive
examples of 3-38
syntax diagram of 3-38
terminating with END-EXEC in
COBOL 3-38
terminating with semicolon in C 3-38
EXECUTE IMMEDIATE statement
C examples of 3-39
COBOL examples of 3-39
syntax diagram of 3-39
EXECUTE statement
C examples of 2-142
COBOL examples of 2-143
MXCI examples of 2-141
scope of 2-139, 2-141
syntax diagram of 2-138
EXISTS predicate
correlated subquery within 6-92
examples of 6-92
syntax diagram of 6-92
EXIT command
active transaction, effect on 4-29
examples of 2-148, 4-29
syntax diagram of 4-29
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-148
operators 2-146
OPTIONS ’m’ considerations 2-147
EXPLAIN statement (continued)
syntax diagram of 2-145
Expression
character (or string) value 6-41
datetime value 6-43, 6-45, 6-50
description of 6-41
interval value 6-45, 6-50
numeric value 6-52
Extended numeric precision 6-18
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-14
FASTCOPY INDEX command
syntax diagram of 5-15
FASTCOPY TABLE command
examples of 5-19
syntax diagram of 5-14
FC command
editing commands using 4-30
examples of 4-31
syntax diagram of 4-30
FEATURE_VERSION_INFO function
example of 9-65
syntax diagram of 9-64
FETCH statement
C examples of 3-43
COBOL examples of 3-44
scope of 3-41
syntax diagram of 3-40