RE: Astonished by embedded sql

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

> -----Message d'origine-----
> De : rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Dennis Lovelady
>
> > It seems to me that this is the equivalent of opening 
> myfile for each 
> > subroutine call, reading every record in the file then closing the 
> > file again.
>
> Yes, that's right.
>
> > Although I'm not sure about the reading. Is the whole file 
> read at the 
> > open cursor statement?
>
> No, but it is read in its entirety at the DoU loop.  (FETCH does the
> lifting.)

Thanks, Dennis. But if the FETCH was executed more than once, it wouldn't be read in its entirety a second time, would it?

> By the way, I didn't think FETCH into *qualified* DS did 
> quite what we would hope.  Perhaps I am mistaken on that.

I didn't even notice. That's going too far! How do you suggest breaking all this to the person who wrote it?