RE: DSPPGMREF and SQLRPG

David,

You blew by the rest of my explanation and ignored it.

Let's say you did have
d myfileds ds extname(myfile) qualified
exec sql select * into :myfileds from myfile where TheKey = :selection;

Now your file layout changes (new field at end) but the program is not
recompiled. Many releases ago the program would still work with just a
minor warning error in the joblog. Now it's a hard halt.

Instead I recommend
d myfileds ds extname(myfile) qualified
exec sql select iNeedThis, iNeedThat into :myfileds.thisField,
:myfileds.thatField from myfile where TheKey = :selection;




Rob Berendt