RE: AW: How can i accumulate amount using SQL

It's call the SQL "scratchpad"

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx 
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Raul A. Jager W.
Sent: Wednesday, August 09, 2006 3:28 PM
To: RPG programming on the AS400 / iSeries
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
 

-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) 
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.