SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Reference Manual—523725-004
viii
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
MXCI Examples of SET TRANSACTION 2-226
C Examples of SET TRANSACTION 2-226
COBOL Examples of SET TRANSACTION 2-226
SIGNAL SQLSTATE Statement 2-227
Considerations for SIGNAL SQLSTATE 2-227
TABLE Statement 2-228
Considerations for TABLE 2-228
Examples of TABLE 2-228
UNLOCK TABLE Statement 2-229
Considerations for UNLOCK TABLE 2-229
Examples of UNLOCK TABLE 2-229
UNREGISTER CATALOG Command 2-230
Considerations for UNREGISTER CATALOG 2-230
Example of UNREGISTER CATALOG 2-230
UPDATE Statement 2-231
Considerations for UPDATE 2-236
MXCI Examples of UPDATE 2-241
C Examples of UPDATE 2-242
COBOL Examples of UPDATE 2-243
Publish/Subscribe Examples of UPDATE 2-243
UPDATE STATISTICS Statement 2-245
Considerations for UPDATE STATISTICS 2-249
Examples of UPDATE STATISTICS 2-252
VALUES Statement 2-254
Considerations for VALUES 2-254
Examples of VALUES 2-254
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