SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)
Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
ix
3. Embedded-Only SQL/MX Statements
C Examples of SET TABLE TIMEOUT 2-298
SET TRANSACTION Statement 2-299
Considerations for SET TRANSACTION 2-301
MXCI Examples of SET TRANSACTION 2-303
C Examples of SET TRANSACTION 2-303
COBOL Examples of SET TRANSACTION 2-303
SIGNAL SQLSTATE Statement 2-304
Considerations for SIGNAL SQLSTATE 2-304
TABLE Statement 2-305
Considerations for TABLE 2-305
Examples of TABLE 2-305
UNLOCK TABLE Statement 2-306
Considerations for UNLOCK TABLE 2-306
Examples of UNLOCK TABLE 2-306
UNREGISTER CATALOG Statement 2-307
Considerations for UNREGISTER CATALOG 2-307
Example of UNREGISTER CATALOG 2-307
UPDATE Statement 2-308
Considerations for UPDATE 2-313
MXCI Examples of UPDATE 2-319
C Examples of UPDATE 2-322
COBOL Examples of UPDATE 2-323
Publish/Subscribe Examples of UPDATE 2-324
UPDATE STATISTICS Statement 2-325
Considerations for UPDATE STATISTICS 2-329
Examples of UPDATE STATISTICS 2-333
VALUES Statement
2-336
Considerations for VALUES 2-336
Examples of VALUES 2-336
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










