SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
7-81
TUPLE_FLOW Operator
For more information about data mining, see the SQL/MX Data Mining Guide.
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.
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
transpose_union_vector Represents a transpose set of the transpose
clause. If multiple transpose sets, then multiple
instances of the token.
ItemExpr
tree
TP663851.fm Page 81 Wednesday, January 30, 2013 5:37 PM