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-9
CURSOR_UPDATE Operator
The following is an example of the CURSOR_DELETE operator:
PREPARE TestQuery1 FROM
DELETE FROM customer
WHERE c_nationkey<300;
DESCRIPTION
olt_optimization ....... used
fragment_id ............ 3
parent_frag ............ 0
fragment_type .......... dp2
Scan_Direction ......... forward
olt_optimization ....... used
olt_opt_lean ........... not used
iud_type ............... index_ cursor_delete
DETCAT.DETSCH.CX1
lock_mode .............. not specified, defaulted to lock
cursor
access_mode ............ not specified, defaulted to read
committed
columns_retrieved ...... 3
begin_key .............. (C_NATIONKEY =
DETCAT.DETSCH.CUSTOMER.C_NATIONKEY)
and (C_CUSTKEY =
DETCAT.DETSCH.CUSTOMER.C_CUSTKEY)
CURSOR_UPDATE Operator
DAM Unique Group
The CURSOR_UPDATE operator describes a portion of an execution plan that works
on one row only. The CURSOR_UPDATE operation is performed by first retrieving
rows from the table and then updating each row that is required. This operation differs
from SUBSET_UPDATE, in which the read and update are performed in a combined
operation.
index_begin_key Expression of the begin key predicates on
index.
expr(text)
part_key_predicate Predicate expression specified on partitioning
key. Displayed only if partitioning key differs
from clustering key.
expr(text)
check_constraint Check constraints in the delete table. expr(text)
TP663851.fm Page 9 Wednesday, January 30, 2013 5:37 PM