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

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
ix
3. Embedded-Only SQL/MX Statements
MXCI Examples of SET TRANSACTION 2-299
C Examples of SET TRANSACTION 2-299
COBOL Examples of SET TRANSACTION 2-299
SIGNAL SQLSTATE Statement 2-300
Considerations for SIGNAL SQLSTATE 2-300
TABLE Statement 2-301
Considerations for TABLE 2-301
Examples of TABLE 2-301
UNLOCK TABLE Statement 2-302
Considerations for UNLOCK TABLE 2-302
Examples of UNLOCK TABLE 2-302
UNREGISTER CATALOG Statement 2-303
Considerations for UNREGISTER CATALOG 2-303
Example of UNREGISTER CATALOG 2-303
UPDATE Statement 2-304
Considerations for UPDATE 2-309
MXCI Examples of UPDATE 2-314
C Examples of UPDATE 2-315
COBOL Examples of UPDATE 2-315
Publish/Subscribe Examples of UPDATE 2-316
UPDATE STATISTICS Statement 2-317
Considerations for UPDATE STATISTICS 2-321
Examples of UPDATE STATISTICS 2-325
VALUES Statement 2-328
Considerations for VALUES 2-328
Examples of VALUES 2-328
3. Embedded-Only SQL/MX Statements
ALLOCATE CURSOR Statement 3-3
Considerations for ALLOCATE CURSOR 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
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