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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xviii
3. Embedded-Only SQL/MX Statements
Considerations for UPGRADE 2-412
Modes of Operation for UPGRADE 2-412
Command Output for UPGRADE 2-412
Error Conditions 2-413
Recovery of a Failed UPGRADE Utility 2-413
Error Conditions 2-414
Example of UPGRADE 2-414
VALUES Statement 2-416
Considerations for VALUES 2-416
Relationship to SELECT Statement 2-416
Examples of VALUES 2-416
3. Embedded-Only SQL/MX Statements
ALLOCATE CURSOR Statement 3-3
Considerations for ALLOCATE CURSOR 3-4
Cursor Names 3-4
Using Extended Dynamic Cursors 3-4
WITH HOLD 3-4
C Examples of ALLOCATE CURSOR 3-4
COBOL Examples of ALLOCATE CURSOR 3-5
Publish/Subscribe Examples of ALLOCATE CURSOR 3-5
ALLOCATE DESCRIPTOR Statement 3-6
Considerations for ALLOCATE DESCRIPTOR 3-6
Defining Values in the Descriptor Area 3-7
Descriptor Names 3-7
C Examples of ALLOCATE DESCRIPTOR
3-7
COBOL Examples of ALLOCATE DESCRIPTOR
3-8
BEGIN DECLARE SECTION Declaration
3-9
C Examples of BEGIN DECLARE SECTION 3-9
C++ Examples of BEGIN DECLARE SECTION 3-9
COBOL Examples of BEGIN DECLARE SECTION
3-10
CLOSE Statement
3-11
Considerations for CLOSE 3-11
Scope of CLOSE
3-11
Reusing a Cursor
3-12
Effect on Locks
3-12
Using Extended Dynamic Cursors
3-12
C Examples of CLOSE 3-12
COBOL Examples of CLOSE
3-13