SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-12
E
DML statements
See Data Manipulation Language
(DML) statements
DOUBLE PRECISION data type 6-35
DP2_CACHE_4096_BLOCKS
default 10-54
DROP CATALOG statement
authorization and availability
requirements 2-119
examples of 2-119
syntax diagram of 2-119
DROP INDEX statement
authorization and availability
requirements 2-120
examples of 2-121
supporting a constraint 2-120
syntax diagram of 2-120
DROP PROCEDURE statement
examples of 2-123
syntax diagram of 2-122
DROP SCHEMA statement
authorization and availability
requirements 2-124
examples of 2-126
syntax diagram of 2-124
DROP SQL statement
authorization and availability
requirements 2-127
examples of 2-127
syntax diagram of 2-127
DROP SQLMP ALIAS statement
examples of 2-129
syntax diagram of 2-128
usage restrictions 2-128
DROP TABLE statement
authorization and availability
requirements 2-130
examples of 2-131
syntax diagram of 2-130
DROP TRIGGER statement
authorization and availability
requirements 2-132
syntax diagram of 2-132
DROP VIEW statement
authorization and availability
requirements 2-133
examples of 2-133
syntax diagram of 2-133
DUP utility 5-4
Dynamic SQL, parameter restrictions 2-164
E
Embedded SQL data manipulation
statements
CLOSE 3-11
FETCH 3-40
OPEN 3-73
Embedded SQL declarations
BEGIN DECLARE SECTION 3-9
DECLARE CATALOG 3-21
DECLARE CURSOR 3-22
DECLARE MPLOC 3-28
DECLARE NAMETYPE 3-31
DECLARE SCHEMA 3-32
END DECLARE SECTION 3-37
MODULE 3-71
WHENEVER 3-87
Embedded SQL diagnostics statement,
GET DIAGNOSTICS 3-56
Embedded SQL dynamic statements
ALLOCATE DESCRIPTOR 3-6
DEALLOCATE DESCRIPTOR 3-16
DEALLOCATE PREPARE 3-18
DESCRIBE 3-33
EXECUTE IMMEDIATE 3-39
SET DESCRIPTOR 3-79
END DECLARE SECTION
C examples of 3-37
COBOL examples of 3-37