SQL/MX 3.x Query Guide (H06.22+, J06.11+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—640323-001
7-76
TUPLELIST Operator
The following is an example of the TUPLE_FLOW operator:
prepare TestQuery38 from
UPDATE table_b SET owner_count = (
SELECT count(*) FROM table_a
WHERE (table_b.col1,table_b.col2)=
(table_a.col1,table_a.col2)
AND table_a.col3 = 1
);
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
transpose_union_vector
ValueIdUnion('0', '1', '2', '3',
'4', '5', '6', '7', '8', '9')
TUPLELIST Operator
Tuple Group
The TUPLELIST operator shows the values that you place in the query when the
VALUES clause is used. The description field for this operator contains:
join_type Inner, left, natural, inner semi, or inner anti-
semi-join.
text
join_method Name of join method:nested or in-order nested
join.
text
join_predicate Expression of the join predicate expr(text)
parallel_join_type Type1 or Type2, depending on parallel join
algorithm
text
selection_predicate Expression of the WHERE clause expr(text)
Token Followed by... Data type
fragment_id A sequential number assigned to the fragment.
0 is always the master executor and 1 is
reserved for the EXPLAIN plan. Numbers 2 to n
will be ESP or DAM fragments.
integer
parent_frag The fragment_id for the parent of the current
fragment. The value is (none) for the master
executor.
integer
fragment_type Master, ESP, or DP2. text
tuple_expr The tuple produced by this node. expr(text)
Token Followed by ... Data Type