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

SQL/MX Operators
HP NonStop SQL/MX Query Guide—640323-001
7-58
SAMPLE Operator
l_discount BETWEEN .06 - 0.01 AND .06 + 0.01
AND l_quantity < 24;
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
xn_access_mode ......... read_only
plan_version ........... 2,200
SCHEMA ................. DETCAT.DETSCH
HASH_JOINS ............. ON
NESTED_JOINS ........... ON
select_list ............
cast(cast((sum((cast(DETCAT.DETSCH.LX3.L_EXTENDEDPRI
CE AS BIG NUM(12,2) SIGNED) *
cast(DETCAT.DETSCH.LX3.L_DISCOUNT
AS BIG NUM(12,2) SIGNED))) /
cast(100 AS BIG NUM(3) SIGNED)) AS
NUMERIC(18,2) SIGNED) AS
NUMERIC(18,2) SIGNED)
SAMPLE Operator
Data Mining Group
The SAMPLE operator occurs as a result of a sample clause in a query.
The SAMPLE operator has one child node. The description field for this operator
contains:
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
sampled_columns List of column references representing the
outputs of the sample operator. Indicates that
the column has been sampled.
expr(text)