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-78
TRANSPOSE Operator
The following is an example of the SUBSET_UPDATE operator:
PREPARE TestQuery20 FROM
UPDATE customer SET c_nationkey = c_nationkey + 1
WHERE c_custkey > 300;
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
Scan_Direction ......... forward
olt_optimization ....... not used
olt_opt_lean ........... not used
iud_type ............... subset_update DETCAT.DETSCH.CUSTOMER
lock_mode .............. not specified, defaulted to lock
cursor
access_mode ............ not specified, defaulted to read
committed
columns_retrieved ...... 8
new_rec_expr ........... (C_NATIONKEY assign (cast(C_NATIONKEY
AS NUMERIC(11) SIGNED) + cast(1 AS
NUMERIC(11) SIGNED)))
begin_key .............. (C_CUSTKEY = 300)
end_key .................. (C_CUSTKEY = <max>)
TRANSPOSE Operator
Data Mining Group
The TRANSPOSE operator occurs as a result of a TRANSPOSE clause.
The TRANSPOSE operator has one child. The description field for this operator
contains:
For more information about data mining, see the SQL/MX Data Mining Guide.
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
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 78 Monday, October 17, 2011 11:48 AM