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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-41
ROOT Operator
The example of the ROOT operator is based on:
SELECT CAST(SUM(l_extendedprice*l_discount) AS NUMERIC(18,2))
AS revenue
FROM lineitem
WHERE l_shipdate >= DATE '1994-01-01'
AND l_shipdate < DATE '1994-01-01' + INTERVAL '1' YEAR
AND l_discount BETWEEN .06 - 0.01 AND .06 + 0.01
AND l_quantity < 24;
211862597551536523 5 ROOT
4 ?
1.0000000E+000 9.8000094E-002 1.5509755E+000 CPU_TIME:
0.350476 IO_TIME: 0.054058 MSG_TIME: 0.068671 IDLETIME: 1.2005
PROBES: 1
select_list: cast(sum((cast(indexcol
(\TESTSYS.$DATA14.SPTPCD.LINEITEM.L_EXTENDEDPRICE)) *
cast(indexcol(\TESTSYS.$DATA14.SPTPCD.LINEITEM.L_DISCOUNT)))))
statement_index: 0
statement: SELECT CAST(SUM(l_extendedprice*l_discount) AS
NUMERIC(18,2)) AS revenue FROM lineitem WHERE l_shipdate >= DATE
'1994-01-01'AND l_shipdate < DATE '1994-01-01' + INTERVAL '1'
YEAR AND l_discount BETWEEN .06 - 0.01 AND .06 + 0.01 AND
l_quantity < 24;
olt_optimization An indicator that shows
whether an optimization for
short, simple operations is
used. The value used is
returned if this optimization is
used.
text
statement_index Statement index of this
statement as reported by the
Measure product.
integer
upd_action_on_error XN_ROLLBACK:
Transaction is rolled back if
an error occurs.
Return: Query stops
executing and error returned
without need for statement
rollback.
Savepoint: DAM savepoints
are used to rollback the
statement if an error occurs.
PARTIAL_UPD: [SQL/MP
style] Partial results are
updated and an error is
returned.
text