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-35
INSERT_VSBB Operator
cursor
access_mode ............ not specified, defaulted to read
committed
columns_retrieved ...... 8
new_rec_expr ........... (C_CUSTKEY assign
DETCAT.DETSCH.CUSTOMER.C_CUSTKEY),
(C_NAME assign
DETCAT.DETSCH.CUSTOMER.C_NAME),
(C_ADDRESS assign
DETCAT.DETSCH.CUSTOMER.C_ADDRESS),
(C_NATIONKEY assign
DETCAT.DETSCH.CUSTOMER.C_NATIONKEY),
(C_PHONE assign
DETCAT.DETSCH.CUSTOMER.C_PHONE),
(C_ACCTBAL assign
DETCAT.DETSCH.CUSTOMER.C_ACCTBAL),
(C_MKTSEGMENT assign
DETCAT.DETSCH.CUSTOMER.C_MKTSEGMENT),
(C_COMMENT assign
DETCAT.DETSCH.CUSTOMER.C_COMMENT)
INSERT_VSBB Operator
INSERT Group
The INSERT_VSBB operator describes that part of an execution plan that inserts
multiple rows into a table in DAM. The operator for an INSERT_VSBB operator is
always INSERT_VSBB.
For information about setting the CONTROL QUERY DEFAULT attribute for
INSERT_VSBB, see the SQL/MX Reference Manual.
The INSERT_VSBB operator has no child nodes. The description field for this operator
contains the following:
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 of the current
fragment. The value is (none) for the master
executor.
integer
fragment_type Master, ESP, or DP2. text
iud_type Type of insert followed by table or index
name.
expr(text)
TP663851.fm Page 35 Wednesday, January 30, 2013 5:37 PM