Re:

["Brian Lawson" <blawson@xxxxxxxxxx>]

Hi Roberto:

The SQL part is no different from my previous post.  You use the /EXEC SQL
the same way but in upper case.
You basically do:
1. Declare the cursor.
2. Open the cursor
3. Fetch the cursor into a data structure.  This retrieves one record.  Loop
until SQLCOD does not = 0.
4. Close the cursor.

HTH,
Brian

-----Original Message-----
From: Roberto Gomes <rgomes5@hotmail.com>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Friday, December 04, 1998 8:08 AM


>SP,04/12/1998
>
>     I would like to know how to insert SQL commands in a RPG400 non-ILE
>program.
>
>
> Thanks,
>
> Roberto Gomes.
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>* This is the RPG/400 Discussion Mailing List!  To submit a new         *
>* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
>* from this list send email to MAJORDOMO@midrange.com and specify       *
>* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
>* be directed to the list owner / operator: david@midrange.com          *
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>
>


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *