SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
viii
2. SQL/MX Statements
SELECT Statement 2-249
Considerations for SELECT 2-265
Considerations for Select List 2-269
Considerations for SEQUENCE BY 2-269
Considerations for GROUP BY 2-270
Considerations for ORDER BY 2-270
Considerations for UNION 2-270
MXCI Examples of SELECT 2-274
C Examples of SELECT 2-279
COBOL Examples of SELECT 2-280
Publish/Subscribe Examples of SELECT 2-280
SELECT ROW COUNT Statement 2-282
Considerations for SELECT ROW COUNT 2-282
Limitations of SELECT ROW COUNT 2-282
Example of SELECT ROW COUNT 2-283
SET Statement 2-284
Considerations for SET Statement 2-284
SET CATALOG Statement 2-285
Considerations for SET CATALOG 2-285
MXCI Examples of SET CATALOG 2-285
C Example of SET CATALOG 2-286
COBOL Example of SET CATALOG 2-286
SET MPLOC Statement 2-287
Considerations for SET MPLOC 2-287
Examples of SET MPLOC 2-287
SET NAMETYPE Statement 2-288
Considerations for SET NAMETYPE
2-288
Examples of SET NAMETYPE 2-288
SET SCHEMA Statement 2-289
Considerations for SET SCHEMA
2-289
MXCI Examples of SET SCHEMA
2-290
C Example of SET SCHEMA 2-290
COBOL Example of SET SCHEMA
2-290
SET TABLE TIMEOUT Statement
2-291
Considerations for SET TABLE TIMEOUT
2-293
MXCI Examples of SET TABLE TIMEOUT
2-293
C Examples of SET TABLE TIMEOUT 2-294
SET TRANSACTION Statement
2-295
Considerations for SET TRANSACTION 2-297