SQL/MX 3.x Query Guide (H06.22+, J06.11+)

SQL/MX Operators
HP NonStop SQL/MX Query Guide—640323-001
7-54
PARTITION_ACCESS 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 following is an example of the PACK operator:
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
pack_expr .............. (cast(JAVCAT.JAVSCH.T.T1 AS INTEGER
SIGNED)RowsetArrayInto 200 ),
(cast(JAVCAT.JAVSCH.T.T2 AS
INTEGER SIGNED) RowsetArrayInto 200),
(cast(JAVCAT.JAVSCH.T.T3 AS INTEGER
SIGNED)RowsetArrayInto 200 )
PARTITION_ACCESS Operator
Exchange Group
Use the PARTITION_ACCESS operator to describe a portion of an execution plan for a
file system interface in which requests are made to DAM. The DAM process runs in
parallel to the PARTITION_ACCESS (no waited interface). For more information about
exchange operators, see Section 8, Parallelism.
The PARTITION_ACCESS operator has one child node. The description field for this
operator contains:
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
pack_expr Expression used to pack values of a row into a
packed row.
expr(text)
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