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

Contents
HP NonStop SQL/MX Reference Manual—640322-001
vii
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
Examples of REVOKE EXECUTE 2-195
ROLLBACK WORK Statement 2-196
Considerations for ROLLBACK WORK 2-196
MXCI Examples of ROLLBACK WORK 2-196
C Examples of ROLLBACK WORK 2-197
COBOL Examples of ROLLBACK WORK 2-197
SELECT Statement 2-198
Considerations for SELECT 2-214
Considerations for Select List 2-218
Considerations for SEQUENCE BY 2-218
Considerations for GROUP BY 2-219
Considerations for ORDER BY 2-219
Considerations for UNION 2-219
MXCI Examples of SELECT 2-223
C Examples of SELECT 2-228
COBOL Examples of SELECT 2-229
Publish/Subscribe Examples of SELECT 2-229
SELECT ROW COUNT Statement 2-231
Considerations for SELECT ROW COUNT 2-231
Limitations of SELECT ROW COUNT 2-231
Example of SELECT ROW COUNT 2-232
SET Statement 2-233
Considerations for SET Statement 2-233
SET CATALOG Statement 2-234
Considerations for SET CATALOG 2-234
MXCI Examples of SET CATALOG 2-234
C Example of SET CATALOG 2-235
COBOL Example of SET CATALOG 2-235
SET MPLOC Statement 2-236
Considerations for SET MPLOC 2-236
Examples of SET MPLOC 2-236
SET NAMETYPE Statement 2-237
Considerations for SET NAMETYPE 2-237
Examples of SET NAMETYPE 2-237
SET SCHEMA Statement 2-238
Considerations for SET SCHEMA 2-238
MXCI Examples of SET SCHEMA 2-239
C Example of SET SCHEMA 2-239