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

Index
HP NonStop SQL/MX Release 3.1 Reference Manual663850-001
Index-13
E
syntax diagram of 2-156
DROP INDEX statement
authorization and availability
requirements 2-157
examples of 2-158
supporting a constraint 2-157
syntax diagram of 2-157
DROP PROCEDURE statement
examples of 2-159
syntax diagram of 2-158
DROP SCHEMA statement
authorization and availability
requirements 2-159
examples of 2-161
limits C-1
syntax diagram of 2-159
DROP SQL statement
authorization and availability
requirements 2-162
examples of 2-162
syntax diagram of 2-162
DROP SQLMP ALIAS statement
examples of 2-164
syntax diagram of 2-163
usage restrictions 2-163
DROP TABLE statement
authorization and availability
requirements 2-165
examples of 2-166
syntax diagram of 2-165
DROP TRIGGER statement
authorization and availability
requirements 2-167
syntax diagram of 2-167
DROP VIEW statement
authorization and availability
requirements 2-168
examples of 2-168
syntax diagram of 2-168
DUP utility 5-8
Dynamic SQL, parameter restrictions 2-225
DYNAMIC_HISTOGRAM_COMPRESSION
default 10-53
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
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-32
ENV command
attributes displayed by 4-25
examples of 4-26
syntax diagram of 4-25
ENVIRONMENTVALUES metadata
table 10-96