Re: having problem with ROLLUP

FWiW, regarding "WITH ROLLUP" syntax:

<http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzgroupbyclause.htm>
"...

_super-groups_

(1)
>>-+-ROLLUP--(--grouping-expression-list--)-----+-----------><
| (2) |
+-CUBE--(--grouping-expression-list--)-------+
'-| grand-total |----------------------------'

Notes:

1. Alternate specification when used alone in group-by-clause is: grouping-expression-list WITH ROLLUP.

2. Alternate specification when used alone in group-by-clause is: grouping-expression-list WITH CUBE.
..."

Regards, Chuck

On 09-Feb-2014 10:34 -0800, paultherrien@xxxxxxxxxxxxxxxxxx wrote:

I think you want to say sum() for calcs and my SQL manual shows a
different format for ROLLUP

SELECT
sum(prt.IDSHP# * IDNTU$), IDDOCD, IDPRT#
FROM DTALIB/OEINDLID prt
WHERE IDDOCD>= 20130101
GROUP by ROLLUP(prt.IDPRT#, prt.IDDOCD)

But I have not used ROLLUP before.

Hoteltravelfundotcom on Sunday, February 09, 2014 12:22 PM wrote:

Here I have a simple thing to do. I want to sum all the part# line
totals in $. which is the (idshp# * IDNTU$) but it is not
compiling.

Column IDSHP# or expression in SELECT list not valid.
SELECT
ALL (((prt.IDSHP#*IDNTU$))), IDDOCD, IDPRT#
FROM DTALIB/OEINDLID prt
WHERE IDDOCD>= 20130101
GROUP by prt.IDPRT#, prt.IDDOCD with Rollup