SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
viii
2. SQL/MX Statements
MXCI Examples of ROLLBACK WORK 2-251
C Examples of ROLLBACK WORK 2-252
COBOL Examples of ROLLBACK WORK 2-252
SELECT Statement 2-253
Considerations for SELECT 2-269
Considerations for Select List 2-273
Considerations for SEQUENCE BY 2-273
Considerations for GROUP BY 2-274
Considerations for ORDER BY 2-274
Considerations for UNION 2-274
MXCI Examples of SELECT 2-278
C Examples of SELECT 2-283
COBOL Examples of SELECT 2-284
Publish/Subscribe Examples of SELECT 2-284
SELECT ROW COUNT Statement 2-286
Considerations for SELECT ROW COUNT 2-286
Limitations of SELECT ROW COUNT 2-286
Example of SELECT ROW COUNT 2-287
SET Statement 2-288
Considerations for SET Statement 2-288
SET CATALOG Statement 2-289
Considerations for SET CATALOG 2-289
MXCI Examples of SET CATALOG 2-289
C Example of SET CATALOG 2-290
COBOL Example of SET CATALOG 2-290
SET MPLOC Statement 2-291
Considerations for SET MPLOC
2-291
Examples of SET MPLOC 2-291
SET NAMETYPE Statement 2-292
Considerations for SET NAMETYPE
2-292
Examples of SET NAMETYPE
2-292
SET SCHEMA Statement 2-293
Considerations for SET SCHEMA
2-293
MXCI Examples of SET SCHEMA
2-294
C Example of SET SCHEMA
2-294
COBOL Example of SET SCHEMA
2-294
SET TABLE TIMEOUT Statement 2-295
Considerations for SET TABLE TIMEOUT
2-297
MXCI Examples of SET TABLE TIMEOUT 2-297