SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-14
F
ERROR command
examples of 4-27
syntax diagram of 4-27
Error messages 1-36
Example for GRANT CREATE
SCHEMA 2-203
Example of GIVE CATALOG 2-196
Examples for REVOKE CREATE
CATALOG 2-235
Examples of ALTER VIEW 2-43
Examples of GET ALL
SECURITY_ADMINS 2-194
Examples of GRANT
SECURITY_ADMIN 2-206
Examples of MODIFY 5-94
Examples of REVOKE
SECURITY_ADMIN 2-239
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-173
COBOL examples of 2-174
MXCI examples of 2-172
scope of 2-170, 2-172
syntax diagram of 2-169
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-179, 4-29
syntax diagram of 4-29
EXP function
examples of 9-60
syntax diagram of 9-60
EXPLAIN function
columns in result 9-62
examples of 9-67
operator tree 9-62
syntax diagram of 9-61
EXPLAIN statement
examples of 2-179
operators 2-177
OPTIONS ’m’ considerations 2-178
syntax diagram of 2-176
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-34
EXTENT file attribute
limits C-1
MAXEXTENTS relationship 8-6
syntax diagram of 8-6
EXTRACT function
examples of 9-70
syntax diagram of 9-70
F
FASTCOPY 5-15
FASTCOPY INDEX command
syntax diagram of 5-18