SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-13
E
DROP SQL statement
authorization and availability
requirements 2-130
examples of 2-130
syntax diagram of 2-130
DROP SQLMP ALIAS statement
examples of 2-132
syntax diagram of 2-131
usage restrictions 2-131
DROP TABLE statement
authorization and availability
requirements 2-133
examples of 2-134
syntax diagram of 2-133
DROP TRIGGER statement
authorization and availability
requirements 2-135
syntax diagram of 2-135
DROP VIEW statement
authorization and availability
requirements 2-136
examples of 2-136
syntax diagram of 2-136
DUP utility 5-4
Dynamic SQL, parameter restrictions 2-183
DYNAMIC_HISTOGRAM_COMPRESSION
default 10-44
E
Embedded SQL data manipulation
statements
CLOSE 3-11
FETCH 3-40
OPEN 3-72
Embedded SQL declarations
BEGIN DECLARE SECTION 3-9
DECLARE CATALOG 3-21
DECLARE CURSOR 3-22
DECLARE MPLOC 3-29
DECLARE NAMETYPE 3-32
Embedded SQL declarations (continued)
DECLARE SCHEMA 3-33
END DECLARE SECTION 3-37
MODULE 3-70
WHENEVER 3-86
Embedded SQL diagnostics statement,
GET DIAGNOSTICS 3-55
Embedded SQL dynamic statements
ALLOCATE DESCRIPTOR 3-6
DEALLOCATE DESCRIPTOR 3-16
DEALLOCATE PREPARE 3-18
DESCRIBE 3-34
EXECUTE IMMEDIATE 3-39
SET DESCRIPTOR 3-78
END DECLARE SECTION
C examples of 3-37
COBOL examples of 3-37
C++ examples of 3-37
syntax diagram of 3-37
Entry-sequenced table 1-31
ENV command
attributes displayed by 4-24
examples of 4-25
syntax diagram of 4-24
ENVIRONMENTVALUES metadata
table 10-86
ERROR command
examples of 4-26
syntax diagram of 4-26
Error messages 1-35
Exclamation point (!) command
examples of 4-27
syntax diagram of 4-27
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