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-231
MXCI Examples of INSERT
ROWS_OUT ................ 33
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.04
DESCRIPTION
max_card_est .......... 33
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
olt_optimization ....... not used
affinity_value 1,687,913,920
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 ............ %(10)
>>execute s1;
--- 2 row(s) inserted.
>>select * from test1;
COL1 COL2
----------- ----
1 100
2 200
11 100
12 200
--- 4 row(s) selected.