Re: AW: SQL/RPG

[CRPence <CRPbottle@xxxxxxxxx>]

  Based on the further detail given in the quoted text, my inference 
what was the original scenario as noted in my previous post, was 
correct.  The given analogy describes in detail the expense [in time] 
involved in using either FETCH or READ versus the SQL summarization. 
The SQL summarization is much more efficient for minimal movement of the 
data.

Regards, Chuck

D Reaper wrote:
> <<SNIP>>
> The RPG programs mimic the following SQL:
>
> insert into SummaryFile
> select Division, sum(Sales) from SalesFile
> group by Division
>
> <<SNIP>>