Re: SQL, the best way for looping

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

-----Original Message-----
From: Stone, Brad V (TC) <bvstone@taylorcorp.com>
To: 'RPG400-L@midrange.com' <RPG400-L@midrange.com>
Date: Friday, May 04, 2001 5:16 PM
Subject: RE: SQL, the best way for looping


>Ahh... so you make sure everything else works before even fetching.
>

Yup. Just like the C people keep telling you... Check your return codes...
ALWAYS.


>Do you really split your SQL stuff into subroutines?  I think I tried it
>once and it wouldn't work.  It wanted them all "in order" in the same
>section of code...
>


Depending upon the complexity of the program, yes, for most real-world
applications.

As for the order, the routines can be arranged that way, so the pre-compiler
can see the cursor names before you open them... etc.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman



+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---