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-80
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 the following:
part_key_predicate Predicate expression specified on partitioning
key. It is displayed only if partitioning key differs
from clustering key.
expr(text)
iud_type Specifies the type of update operator. Could be
subset_update, unique_update, or
cursor_update.
expr(text)
selection_predicate Predicate specified in the WHERE clause of a
query.
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
TP663851.fm Page 80 Wednesday, January 30, 2013 5:37 PM