SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xix
3. Embedded-Only SQL/MX Statements
Compound (BEGIN...END) Statement 3-14
Considerations for Compound Statement 3-14
SQL Statements in the List 3-14
Executing Compound Statements in a DAM Process 3-14
SELECT Statements Within Compound Statements 3-15
C Examples of Compound Statement 3-15
DEALLOCATE DESCRIPTOR Statement 3-16
C Examples of DEALLOCATE DESCRIPTOR 3-17
COBOL Examples of DEALLOCATE DESCRIPTOR 3-17
DEALLOCATE PREPARE Statement 3-18
Considerations for DEALLOCATE PREPARE 3-19
Cursor Specification 3-19
C Examples of DEALLOCATE PREPARE 3-19
COBOL Examples of DEALLOCATE PREPARE 3-20
DECLARE CATALOG Declaration 3-21
Considerations for DECLARE CATALOG 3-21
Scope of DECLARE CATALOG 3-21
C Examples of DECLARE CATALOG 3-21
COBOL Examples of DECLARE CATALOG 3-21
DECLARE CURSOR Declaration 3-22
Considerations for DECLARE CURSOR 3-24
Default for Updatability 3-24
Order of Cursor Operations 3-25
Declaring Host Variables 3-25
WITH HOLD 3-25
C Examples of DECLARE CURSOR 3-25
COBOL Examples of DECLARE CURSOR
3-26
Publish/Subscribe Examples of DECLARE CURSOR 3-28
DECLARE MPLOC Declaration 3-29
Considerations for DECLARE MPLOC
3-30
Preprocessor and INVOKE Directive
3-30
Scope of DECLARE MPLOC 3-30
C Examples of DECLARE MPLOC
3-30
COBOL Examples of DECLARE MPLOC
3-31
DECLARE NAMETYPE Declaration
3-32
Considerations for DECLARE NAMETYPE
3-32
Scope of DECLARE NAMETYPE 3-32
C Examples of DECLARE NAMETYPE
3-32
COBOL Examples of DECLARE NAMETYPE 3-32