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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xv
2. SQL/MX Statements
Considerations for SELECT 2-345
Multiple Row and Single Row SELECT Statements 2-345
Authorization Requirements 2-346
Transactions 2-346
Locking Modes 2-346
Use of Views With SELECT 2-346
Join Limits 2-347
Object Names in SELECT 2-347
AS and ORDER BY Conflicts 2-347
Stream Access Restrictions 2-347
Joining the Results of an Embedded Delete or Update 2-348
Restrictions on Embedded Deletes and Updates 2-348
DISTINCT Aggregate Functions 2-348
Considerations for Select List 2-349
Considerations for SEQUENCE BY 2-349
Considerations for GROUP BY 2-350
Considerations for ORDER BY 2-350
Considerations for UNION 2-350
Characteristics of the UNION Columns 2-350
ORDER BY Clause and the UNION Operator 2-352
GROUP BY Clause, HAVING Clause, and the UNION Operator 2-352
UNION ALL and Associativity 2-352
Access Modes and the UNION Operator 2-353
MXCI Examples of SELECT 2-354
C Examples of SELECT 2-359
COBOL Examples of SELECT 2-360
Publish/Subscribe Examples of SELECT
2-360
SELECT ROW COUNT Statement 2-362
Considerations for SELECT ROW COUNT 2-362
Limitations of SELECT ROW COUNT
2-362
Example of SELECT ROW COUNT
2-363
SET Statement 2-364
Considerations for SET Statement
2-364
SET CATALOG Statement
2-365
Considerations for SET CATALOG
2-365
Scope of SET CATALOG
2-365
MXCI Examples of SET CATALOG 2-365
C Example of SET CATALOG
2-366
COBOL Example of SET CATALOG 2-366