Re: CHAIN vs. SETLL (was Re: DOW vs DOU)

["James W. Kilgore" <qappdsn@xxxxxxx>]

John Carr wrote:
> 
<snip>
> 
> Personally  I find them all bulky.   The following works even if I don't have
> that index being
> used in my program.
> 
> C/EXEC-SQL
> C+                                DELETE   FROM RECD1
> C+                                 WHERE   filefieldname  =  :KEY1
> C/END-EXEC
> 
> Of  course if I were to use a loop  I would use the more correct one.
> That being  a SETLL/DOU/LEAVE   loop,   but we've heard that before.   ITER
> ,ITER
> 
John,

I liked the ITER, ITER part :-)

Should we all live in a world where the clients have DB2 and SQL!

-- 
===================================================
James W. Kilgore   | Progressive Data Systems, Inc.
President          | 311 31st Ave SE
(206) 848-2567     | Puyallup, Washington 98374 USA
qappdsn@ibm.net    | http://www.ultimate.org/PDS
===================================================
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *