SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Contents
HP NonStop SQL/MX Reference Manual—640322-001
viii
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
COBOL Example of SET SCHEMA 2-239
SET TABLE TIMEOUT Statement 2-240
Considerations for SET TABLE TIMEOUT 2-242
MXCI Examples of SET TABLE TIMEOUT 2-242
C Examples of SET TABLE TIMEOUT 2-243
SET TRANSACTION Statement 2-244
Considerations for SET TRANSACTION 2-246
MXCI Examples of SET TRANSACTION 2-248
C Examples of SET TRANSACTION 2-248
COBOL Examples of SET TRANSACTION 2-248
SIGNAL SQLSTATE Statement 2-249
Considerations for SIGNAL SQLSTATE 2-249
TABLE Statement 2-250
Considerations for TABLE 2-250
Examples of TABLE 2-250
UNLOCK TABLE Statement 2-251
Considerations for UNLOCK TABLE 2-251
Examples of UNLOCK TABLE 2-251
UNREGISTER CATALOG Statement 2-252
Considerations for UNREGISTER CATALOG 2-252
Example of UNREGISTER CATALOG 2-252
UPDATE Statement 2-253
Considerations for UPDATE 2-258
MXCI Examples of UPDATE 2-263
C Examples of UPDATE 2-264
COBOL Examples of UPDATE 2-264
Publish/Subscribe Examples of UPDATE 2-265
UPDATE STATISTICS Statement 2-266
Considerations for UPDATE STATISTICS 2-270
Examples of UPDATE STATISTICS 2-274
VALUES Statement 2-277
Considerations for VALUES 2-277
Examples of VALUES 2-277
3. Embedded-Only SQL/MX Statements
ALLOCATE CURSOR Statement 3-3
Considerations for ALLOCATE CURSOR 3-4
C Examples of ALLOCATE CURSOR 3-4