SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xvi
2. SQL/MX Statements
SET MPLOC Statement 2-367
Considerations for SET MPLOC 2-367
Scope of SET MPLOC 2-367
Examples of SET MPLOC 2-367
SET NAMETYPE Statement 2-368
Considerations for SET NAMETYPE 2-368
Scope of SET NAMETYPE 2-368
Examples of SET NAMETYPE 2-368
SET SCHEMA Statement 2-369
Considerations for SET SCHEMA 2-369
Scope of SET SCHEMA 2-369
MXCI Examples of SET SCHEMA 2-370
C Example of SET SCHEMA 2-370
COBOL Example of SET SCHEMA 2-370
SET TABLE TIMEOUT Statement 2-371
Considerations for SET TABLE TIMEOUT 2-373
MXCI Examples of SET TABLE TIMEOUT 2-373
C Examples of SET TABLE TIMEOUT 2-374
SET TRANSACTION Statement 2-375
Considerations for SET TRANSACTION 2-377
Implicit Transactions 2-377
Explicit Transactions 2-378
Degree of Concurrency 2-378
Effect on Utilities 2-378
MXCI Examples of SET TRANSACTION 2-379
C Examples of SET TRANSACTION 2-379
COBOL Examples of SET TRANSACTION
2-379
SIGNAL SQLSTATE Statement 2-380
Considerations for SIGNAL SQLSTATE 2-380
TABLE Statement
2-381
Considerations for TABLE
2-381
Relationship to SELECT Statement 2-381
Examples of TABLE
2-381
UNLOCK TABLE Statement
2-382
Considerations for UNLOCK TABLE
2-382
Authorization Requirements
2-382
Examples of UNLOCK TABLE 2-382
UNREGISTER CATALOG Statement
2-383
Considerations for UNREGISTER CATALOG 2-383