SQL/MX 2.x Reference Manual (H06.04+)

Contents
HP NonStop SQL/MX Reference Manual—540440-003
viii
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
MXCI Examples of SET TRANSACTION 2-221
C Examples of SET TRANSACTION 2-221
COBOL Examples of SET TRANSACTION 2-221
SIGNAL SQLSTATE Statement 2-222
Considerations for SIGNAL SQLSTATE 2-222
TABLE Statement 2-223
Considerations for TABLE 2-223
Examples of TABLE 2-223
UNLOCK TABLE Statement 2-224
Considerations for UNLOCK TABLE 2-224
Examples of UNLOCK TABLE 2-224
UNREGISTER CATALOG Statement 2-225
Considerations for UNREGISTER CATALOG 2-225
Example of UNREGISTER CATALOG 2-225
UPDATE Statement 2-226
Considerations for UPDATE 2-231
MXCI Examples of UPDATE 2-236
C Examples of UPDATE 2-237
COBOL Examples of UPDATE 2-237
Publish/Subscribe Examples of UPDATE 2-238
UPDATE STATISTICS Statement 2-239
Considerations for UPDATE STATISTICS 2-243
Examples of UPDATE STATISTICS 2-246
VALUES Statement 2-248
Considerations for VALUES 2-248
Examples of VALUES 2-248
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