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

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].