SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-14
F
ERROR command
examples of 4-27
syntax diagram of 4-27
Error messages 1-37
Example for GRANT CREATE
SCHEMA 2-246
Example of GIVE CATALOG 2-236
Examples for REVOKE CREATE
CATALOG 2-321
Examples of ALTER VIEW 2-50
Examples of DATEADD 8-47
Examples of GET ALL
SECURITY_ADMINS 2-234
Examples of GRANT
SECURITY_ADMIN 2-250
Examples of MODIFY 2-296
Examples of REVOKE
SECURITY_ADMIN 2-326
Exclamation point (!) command
examples of 4-28
syntax diagram of 4-28
EXCLUSIVE lock mode 1-12
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-205
COBOL examples of 2-206
MXCI examples of 2-204
scope of 2-202, 2-204
syntax diagram of 2-201
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-211, 4-29
syntax diagram of 4-29
EXP function
examples of 8-65
syntax diagram of 8-65
EXPLAIN function
columns in result 8-67
examples of 8-72
operator tree 8-67
syntax diagram of 8-66
EXPLAIN statement
examples of 2-211
operators 2-209
OPTIONS ’m’ considerations 2-210
syntax diagram of 2-208
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-35
EXTENT file attribute
limits C-1
MAXEXTENTS relationship 9-6
syntax diagram of 9-6
EXTRACT function
examples of 8-75
syntax diagram of 8-75
F
FASTCOPY 5-7
FASTCOPY INDEX command