SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-324
MXCI Examples of UPDATE
-------------------------------------------------------------
----- NODE LISTING
ROOT ====================================== SEQ_NO 15
ONLY CHILD 14
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.06
DESCRIPTION
max_card_est ........... 1
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
olt_optimization ....... not used
affinity_value 1,206,279,158
est_memory_per_cpu .... 57
upd_action_on_error .... savepoint
xn_autoabort_interval -1
plan_version ....... 3,200
self_referencing_update forced_sort
MXCI_PROCESS ........... ON
SHOWCONTROL_UNEXTERNALI OFF
BLOCK_TO_PREVENT_HALLOW ON
select_list ............ %(300), %(300), execution_count
>>execute s1;
--- 1 row(s) updated.
>>select * from test1;
COL1 COL2
----------- ----
1 100
300 200
--- 2 row(s) selected.