re: sql question

[<groyle@xxxxxxxx> (Gordon S. Royle)]

You would use a cursor. General syntax follows:

C/EXEC SQL DECLARE XXX CURSOR FOR                                     
C+ SELECT fields                                 
C+ FROM table                                                      
C+ WHERE index-value >= host-variable (with SETLL value in 
it)                        
C+ GROUP BY some-selected-field(s)     
C+ ORDER BY some-selected-field(s)             
C/END-EXEC                                                             
*                                                                     
C/EXEC SQL                                                     
C+ OPEN XXX                                                   
C/END-EXEC                                                     
C*                                                             
C* If cursor is already open, close it and re-open it again    
C                   If        SqlCod = -502                    
C/EXEC SQL                                                     
C+ CLOSE XXX                                                  
C/END-EXEC                                                     
C/EXEC SQL                                                     
C+ OPEN XXX                                                   
C/END-EXEC                                                     
C                   Endif                                      
C*                                                             

EXEC SQL                    
 FETCH XXX INTO            
       host-variables (one for each field selected)     
END-EXEC                    

Gord Royle
Cott Corporation
---------- Original Text ----------

From: "Smith, Mike" <Mike_Smith@RGCResources.com>, on 4/4/01 9:02 AM:

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




_______________________________________________________________

Cott - The Leader in Premium Retailer Brand Beverage Innovation. 
_______________________________________________________________
+---
| 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
+---