SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Contents
HP NonStop SQL/MX Reference Manual—544517-008
viii
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
SET TRANSACTION Statement 2-240
Considerations for SET TRANSACTION 2-242
MXCI Examples of SET TRANSACTION 2-244
C Examples of SET TRANSACTION 2-244
COBOL Examples of SET TRANSACTION 2-244
SIGNAL SQLSTATE Statement 2-245
Considerations for SIGNAL SQLSTATE 2-245
TABLE Statement 2-246
Considerations for TABLE 2-246
Examples of TABLE 2-246
UNLOCK TABLE Statement 2-247
Considerations for UNLOCK TABLE 2-247
Examples of UNLOCK TABLE 2-247
UNREGISTER CATALOG Statement 2-248
Considerations for UNREGISTER CATALOG 2-248
Example of UNREGISTER CATALOG 2-248
UPDATE Statement 2-249
Considerations for UPDATE 2-254
MXCI Examples of UPDATE 2-259
C Examples of UPDATE 2-260
COBOL Examples of UPDATE 2-260
Publish/Subscribe Examples of UPDATE 2-261
UPDATE STATISTICS Statement 2-262
Considerations for UPDATE STATISTICS 2-266
Examples of UPDATE STATISTICS 2-270
VALUES Statement 2-273
Considerations for VALUES 2-273
Examples of VALUES 2-273
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