Good News Everybody!
The new search engine is LIVE!
Please report any problems to david (at) midrange.com.
|
In free format you can do things more like you're thinking of, like
/free
x=y;
exec sql declare c1 cursor for ...;
exec sql open c1;
loop=*on;
dow loop;
exec sql fetch c1 into ...;
if sqlstt> ...;
loop=*off;
else;
// main body
EndIf;
EndDo;
*inlr=*on;
exec sql close c1;
return;
/end-free
However, when stuck in V5R3 and before I started breaking everything down
into subprocedures
/free
OpenCursor();
dow FetchCursor();
// main body
EndDo;
CloseCursor();
*inlr=*on
return;
/end-free
Made for a nice looping structure and put the ugly fixed format stuff down
into subprocedures.
Rob Berendt
This mailing list archive is Copyright 1997-2026 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.