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

SQL/MX Operators
HP NonStop SQL/MX Query Guide—640323-001
7-75
TUPLE_FLOW Operator
The following is an example of the TRANSPOSE operator:
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 of the current
fragment. The value is (none) for the master
executor.
integer
fragment_type Master, ESP, or DP2. text