Re: sql question

Hi Mike,

Here's what we use (just an example):

C**
C**   SETLL OF SCTBL1
C**
C/EXEC SQL
C+ DECLARE CR1 CURSOR FOR
C+ SELECT *
C+ FROM SCTBL1
C+ WHERE C1CNST >= :S1CNST
C+ AND   C1ATFG = 'A'
C+ ORDER BY C1CNST
C/END-EXEC

followed by:

C/EXEC SQL
C+    OPEN CR1
C/END-EXEC
C**

and:

C**
C/EXEC SQL
C+          FETCH CR1
C+          INTO  :DSSCT1
C/END-EXEC

In this example DSSCT1 is an externally described data structure of the file in
question.

Hope this helps you.

Peter

"Smith, Mike" <Mike_Smith@RGCResources.com> on 04/04/2001 03:02:29 PM


Please respond to RPG400-L@midrange.com

From:"Smith, Mike" <Mike_Smith@RGCResources.com> on 04/04/2001 03:02 PM



To:  "'RPG400-L@midrange.com'" <RPG400-L@midrange.com>
cc:  (bcc: Peter Colpaert/HE/EU/HONDA)

Subject:  sql question







is there(i'm sure there is- i just don't know it) an sql equivelant for a
SETLL .
i have a program that loads a page at a time subfile, that i'm trying to
modify to us embedded SQL to load the SUBFILE.  The program has SETLL
scattered through out and i'm not sure what i would replace these with using
SQL.

Thanks

Mike

+---
| 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
+---






+---
| 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
+---