Re: having problem with ROLLUP

[CRPence <CRPbottle@xxxxxxxxx>]

  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