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

SQL/MX Operators
HP NonStop SQL/MX Query Guide—540437-005
7-81
VALUES Operator
Create a module file. For details on creating module file, see the SQL/MX
Programming Manual for C and COBOL.
Now execute the following command:
explain <name of a statement in module file> from <name of
module file>
The example of the UNPACK operator is based on:
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
unpack_expression ...... (:a RowsetArrayScan
\:_sys_rowset_index1),
(:b
RowsetArrayScan\:_sys_rowset_index1),
(:c
RowsetArrayScan\:_sys_rowset_index1)
packing_factor ......... 200
index_value .............. \:_sys_rowset_index1
VALUES Operator
Tuple Group
The VALUES operator calculates an expression for each row it receives from its child
node and returns that expression to its parent node.
The VALUES operator has one child node. The description field for this operator
contains:
unpack_expression Expression used to extract values from a
packed row
expr(text)
index_value System-generated index used when accessing
a packed row
expr(text)
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.
integer
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