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

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-72
SUBSET_UPDATE Operator
This operator has no 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
begin_key Expression of the begin key predicates on the
clustering key columns of the table or index.
expr(text)
index_begin_key Expression of the begin key predicates on
index.
expr(text)
end_key Expression of the end key predicates on the
clustering key columns of the table or index.
expr(text)
index_end_key Expression of the end key predicates on index. expr(text)
check_constraint Check constrains in the update table. expr(text)
scan_type Physical scan associated with the scan logical
operator.
text
scan_direction Direction in which table is scanned: forward or
reverse.
text
lock_mode The lock mode specified: shared, exclusive, not
specified (defaulted to lock cursor), or unknown.
text
access_mode The access specified: read uncommitted, skip
conflict, read committed, stable, serializable,
mx serializable, not specified (defaulted to read
committed), or unknown.
text
new_rec_expr Computation of the row to be updated. expr(text)
columns_retrieved Estimate of the number of columns to be
returned.
integer
predicate Predicate used in the UPDATE statement. expr(text)
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)