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

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-31
INSERT Operator
INSERT Operator
INSERT Group
The INSERT operator describes that part of an execution plan that inserts a new row
into a table. The operator for an INSERT operator is always INSERT.
The INSERT operator has no child nodes. The description field for this operator
contains:
The example of the INSERT operator is based on:
PREPARE TestQuery8 FROM
INSERT INTO custss SELECT *
FROM customer
WHERE c_nationkey IN (1,3,7,8,10,15,18,20,22,44);
DESCRIPTION
fragment_id ............ 3
parent_frag ............ 0
fragment_type .......... dp2
olt_optimization ....... not used
olt_opt_lean ........... not used
iud_type ............... insert DETCAT.DETSCH.CUSTSS
lock_mode .............. not specified, defaulted to lock
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
new_rec_expr Computation of the row to be inserted. expr(text)
olt_optimization Indicates whether an optimization for short,
simple operations is used. Its value is used or
not used.
text
olt_opt_lean Indicates for short, simple operations whether a
further optimization that reduces the physical
size of the plan is used. Its value is used or
not used.
text
part_key_predicate Predicate expression specified on the
partitioning key. Displayed only if partitioning
key differs from clustering key.
expr(text)
iud_type Type of insert followed by table or index name. expr(text)
check_constraint Check constrains in the insert table. expr(text)