simulated SETLL with SQL

[Mark Walter <mwalter@xxxxxxxxxx>]

Hello all,

Welcome back all who attended COMMON. I hope everyone found the conference 
stimulating.

I am attempting, for lack of a better term, a "work with" screen in which I 
want to dynamically change the sort order of data in a subfile. I have a 
window with a single choice field to select the sort order. I am doing all 
of the record selection with SQL. (declaring a cursor, opening the cursor, 
fetching the rows into the subfile, closing the cursor)

My problem is the original screen (which had only one sort) had a position 
to field. I need to know how to simulate a SETLL and READ with SQL. I would 
also like to know if I can place the sort field into a host variable. 
Currently I declare and utilize a different cursor for each possible sort.

thanks in advance

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