SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
iv
7. SQL/MX Operators
7. SQL/MX Operators
Operators 7-5
BLOCKED_UNION Operator 7-5
CALL Operator 7-6
CURSOR_DELETE Operator 7-8
CURSOR_UPDATE Operator 7-9
ESP_ACCESS Operator 7-11
ESP_EXCHANGE Operator 7-12
EXE_LONG_RUNNING Operator 7-16
EXPLAIN Operator
7-17
EXPR Operator
7-17
EXPLAIN_CMD Operator 7-18
FILE_SCAN Operator 7-18
FILE_SCAN_UNIQUE Operator 7-20
FirstN Operator 7-23
HASH_GROUPBY Operator 7-23
HASH_PARTIAL_GROUPBY_LEAF Operator 7-25
HASH_PARTIAL_GROUPBY_ROOT Operator 7-26
HYBRID_HASH_ANTI_SEMI_JOIN Operator 7-27
HYBRID_HASH_JOIN Operator 7-28
HYBRID_HASH_SEMI_JOIN Operator 7-29
INDEX_SCAN Operator 7-30
INDEX_SCAN_UNIQUE Operator 7-32
INSERT Operator 7-34
INSERT_VSBB Operator
7-35
LEFT_HYBRID_HASH_JOIN Operator 7-36
LEFT_MERGE_JOIN Operator
7-37
LEFT_NESTED_JOIN Operator
7-39
LEFT_ORDERED_HASH_JOIN Operator
7-40
MATERIALIZE Operator 7-41
MERGE_ANTI_SEMI_JOIN Operator
7-42
MERGE_JOIN Operator
7-43
MERGE_SEMI_JOIN Operator 7-45
MERGE_UNION Operator 7-46
MultiUnion Operator
7-47
NESTED_ANTI_SEMI_JOIN Operator
7-47
NESTED_JOIN Operator 7-48
NESTED_SEMI_JOIN Operator 7-50
NEXTVALUEFOR Operator 7-51
TP663851.fm Page iv Thursday, August 2, 2012 4:47 PM