SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
7-3
Group Operator
User-Defined
Routine
CALL
DAM Subset FILE_SCAN
INDEX_SCAN
SUBSET_DELETE
SUBSET_UPDATE
DAM Unique CURSOR_DELETE
CURSOR_UPDATE
FILE_SCAN_UNIQUE
INDEX_SCAN_UNIQUE
UNIQUE_DELETE
UNIQUE_UPDATE
Data Mining SAMPLE
SEQUENCE
TRANSPOSE
Exchange ESP_EXCHANGE
PARTITION_ACCESS
SPLIT_TOP
Groupby HASH_GROUPBY
HASH_PARTIAL_GROUPBY_LEAF
HASH_PARTIAL_GROUPBY_ROOT
SHORTCUT_SCALAR_AGRR
SORT_GROUPBY
SORT_PARTIAL_AGGR_LEAF
SORT_PARTIAL_AGGR_ROOT
SORT_PARTIAL_GROUPBY_LEAF
SORT_PARTIAL_GROUPBY_ROOT
SORT_SCALAR_AGGR
Insert INSERT
INSERT_VSBB
TP663851.fm Page 3 Monday, October 17, 2011 11:48 AM