SQL/MX 2.x Query Guide (H06.04+, J06.03+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-74
TUPLE_FLOW Operator
The example of the TRANSPOSE operator is based on:
prepare TestQuery23 from
insert into T061_T232OR1
(
select
cast(c1 || c2 || c3 || c4 || c5 as int),
cast(c1 || c2 || c3 || c4 || c5 as int),
cast(c1 || c2 || c3 || c4 || c5 as int),
cast(c1 || c2 || c3 || c4 || c5 as int)
from
(values(1)) t
transpose '0', '1', '2', '3', '4', '5', '6', '7', '8', '9'
as c1
transpose '0', '1', '2', '3', '4', '5', '6', '7', '8', '9'
as c2
transpose '0', '1', '2', '3', '4', '5', '6', '7', '8', '9'
as c3
transpose '0', '1', '2', '3', '4', '5', '6', '7', '8', '9'
as c4
transpose '0', '1', '2', '3', '4', '5', '6', '7', '8', '9'
as c5
);
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
transpose_union_vector
ValueIdUnion('0', '1', '2', '3',
'4', '5', '6', '7', '8', '9')
TUPLE_FLOW Operator
Join Group
The TUPLE_FLOW operator describes a portion of an execution plan that involves a
nested join. This operator enables data to flow from one child to the other.
The TUPLE_FLOW operator has two child nodes. The description field for this operator
contains:
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 fragment of the
current fragment. The value is (none) for the
master executor.
integer
fragment_type Master, ESP, or DP2. text