SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)
Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-14
F
ENVIRONMENTVALUES metadata
table 10-99
ERROR command
examples of 4-27
syntax diagram of 4-27
Error messages 1-37
Example for GRANT CREATE
SCHEMA 2-211
Example of GIVE CATALOG 2-203
Examples for REVOKE CREATE
CATALOG 2-246
Examples of ALTER VIEW 2-43
Examples of DATEADD 9-47
Examples of GET ALL
SECURITY_ADMINS 2-201
Examples of GRANT
SECURITY_ADMIN 2-214
Examples of MODIFY 5-101
Examples of REVOKE
SECURITY_ADMIN 2-251
Exclamation point (!) command
examples of 4-28
syntax diagram of 4-28
EXCLUSIVE lock mode 1-13
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-180
COBOL examples of 2-181
MXCI examples of 2-179
scope of 2-177, 2-179
syntax diagram of 2-176
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-186, 4-29
syntax diagram of 4-29
EXP function
examples of 9-65
syntax diagram of 9-65
EXPLAIN function
columns in result 9-67
examples of 9-72
operator tree 9-67
syntax diagram of 9-66
EXPLAIN statement
examples of 2-186
operators 2-184
OPTIONS ’m’ considerations 2-185
syntax diagram of 2-183
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 8-6
syntax diagram of 8-6
EXTRACT function
examples of 9-75
syntax diagram of 9-75
F
FASTCOPY 5-21










