Re: RPG400-L Digest, Vol 5, Issue 929

what does it mean of  Scratchpad and how to coding this statement in SQL
UDF?



date: Mon, 14 Aug 2006 11:14:27 -0500

from: "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
subject: RE: AW: How can i accumulate amount using SQL

Scratchpad....

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, August 09, 2006 2:40 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: AW: How can i accumulate amount using SQL


Something about this seems familiar also.  I didn't find anything on a
cursory search.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Raul A. Jager W." <raul@xxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/09/2006 03:28 PM
Please respond to
RPG programming on the AS400 / iSeries rpg400-l@xxxxxxxxxxxx



Subject
Re: AW: How can i accumulate amount using SQL



I remember reading about UDF that can hold some info from call to call,
but I have never used it.  Sounds worht to investigate, once you find
out how, a simple function will do what yuo need.

HauserSSS wrote:

>Hi,
>
>try the following SQL-Statement:
>
>Select   a.Name, sum(a.amount) as Total,
>         (Select   sum(b.amount)
>             from  test b
>             where a.Name >= b.Name) as Cumul
>   from  test a
>  group  by a.Name
>
>Mit freundlichen Gru?en / Best regards
>
>Birgitta
>
>"Shoot for the moon, even if you miss, you'll land among the stars."
>(Les Brown)
>
>-----Ursprungliche Nachricht-----
>Von: rpg400-l-bounces@xxxxxxxxxxxx
>[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von 2046 BBQ
>Gesendet: Mittwoch, 9. August 2006 17:53
>An: RPG400-L@xxxxxxxxxxxx
>Betreff: How can i accumulate amount using SQL
>
>
> i want to do like that in sql
>
> name      amount     accumulate(amount)
>peter         100.00              100.00
>John          100.00              200.00
>Mary          120.00              320.00
>
>