SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-56
UNPACK Operator
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_D_ID(98)}) and
VEGPred_124(VEG{ORDERS.O_ID(17),
\TESTSYS.$BIG18B.OEQA8.ORDERS.O_ID(25),
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_ID(44),
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_ID(47),?O_ID(63),
"\TESTSYS.$SQL09".OEQA8.ORDERS.O_ID(69),
\TESTSYS.$BIG18B.OEQA8.ORDERS.O_ID(77),
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_ID(96),
\TESTSYS.$BIG18B.OEQA8.ORDER1.O_ID(99)})
begin_key: (indexcol(\TESTSYS.$BIG18B.OEQA8.ORDERS.O_W_ID) =
?W_ID) and (indexcol(\TESTSYS.$BIG18B.OEQA8.ORDERS.O_D_ID) =
?D_ID) and (indexcol(\TESTSYS.$BIG18B.OEQA8.ORDERS.O_ID) =
?O_ID) end_key: (indexcol(\TESTSYS.$BIG18B.OEQA8.ORDERS.O_W_ID)
= ?W_ID) and (indexcol(\TESTSYS.$BIG18B.OEQA8.ORDERS.O_D_ID) =
?D_ID) and (indexcol(\TESTSYS.$BIG18B.OEQA8.ORDERS.O_ID) =
?O_ID) olt_optimization: used
UNPACK Operator
Rowset Group
Use the UNPACK operator in a query plan when an array is used as input in a query
(for example, inserting rows from rowset arrays). The UNPACK operator extracts the
elements from the array to use in the query. For more information about rowsets and
arrays, see the SQL/MX Programming Manual for C and COBOL.
The UNPACK operator has one child. The description field for this operator contains:
Token Followed by ... Data Type
unpack_expression Expression used to extract
values from a packed row
expr(text)
index_value System-generated index
used when accessing a
packed row
integer
packing_factor Used to extract the packing
factor from the packed row.
The packing factor is the
number of logical rows in the
packed row.
expr(text)