SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-14
F
EXECUTE statement (continued)
scope of 2-132, 2-134
syntax diagram of 2-131
EXISTS predicate
correlated subquery within 6-88
examples of 6-88
syntax diagram of 6-88
EXIT command
active transaction, effect on 4-28
examples of 4-28
syntax diagram of 4-28
EXP function
examples of 9-51
syntax diagram of 9-51
EXPLAIN function
columns in result 9-53
DISPLAY_EXPLAIN command 9-53
examples of 9-56
operator tree 9-53
syntax diagram of 9-52
Expression
character (or string) value 6-37
datetime value 6-39, 6-41, 6-46
description of 6-37
interval value 6-41, 6-46
numeric value 6-48
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-59
syntax diagram of 9-59
F
FC command
editing commands using 4-29
examples of 4-30
syntax diagram of 4-29
FETCH statement
C examples of 3-42
COBOL examples of 3-43
scope of 3-40
syntax diagram of 3-39
using host variables 3-40
FFDC_DIALOUTS_FOR_MXCMP
default 10-55
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
File options
CREATE INDEX use of 2-52
CREATE TABLE use of 2-74
STORE BY 2-81, 7-22
File organizations
entry-sequenced 1-31
key-sequenced 1-31
relative 1-31
restrictions on 1-31
First (partition) keys 6-57
Fixed-length character column 6-21
FIXUP operation 5-11
FLOAT data type 6-33
Floating-point data, description of 6-17