RE: SQL question

I guess I ended up doing something similar, but possibly more work.  It works 
though.  I looped through my file and did my summary functions.  Then I looped 
back through to delete.

Thanks.

-----Original Message-----
From: Carel Teijgeler [mailto:coteijgeler@xxxxxxxxx]
Sent: Friday, April 04, 2003 12:52 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: SQL question


Mike,

Why not do SELECT the required fields, do some SUMming, COUNTing, etc (and 
GROUPING) in the DECLARE CURSOR statement.

After the loop EXECUTE IMEDIATELY the DELETE.

Regards,
Carel Teijgeler.

*********** REPLY SEPARATOR  ***********

On 4-4-03 at 12:10 Mike Haston ** Data wrote:

>I'm trying to roll through a file and create a summary file, then delete
>the record (row) I just read.  I'm wondering if I need to do the delete
>separately because it's getting some weird output!
>
>If I comment out the delete code, it creates my summary file just fine. 
>When I open the delete code back up it doesn't create the summary file or
>do the delete!
>
>Here's the snippets:



_______________________________________________
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.