RE: different iterations of SQL run statements in same program

1. Prepare statement 
2. Declare cursor from prepared statement
3. Open cursor
4. Fetch from cursor
5. Close cursor (drop) 
6. Alter statement, repeat.

Steps 1 thru three MUST all appear in the source (sequentially) before the
remaining.



Thank you,
Matt Tyler
WinCo Foods, Inc
mattt@xxxxxxxxxxxxxx

-----Original Message-----
From: Dan Bale [mailto:dbale@xxxxxxxxxxxxx]
Sent: Wednesday, September 15, 2004 9:12 a
To: RPG400-L@xxxxxxxxxxxx
Subject: different iterations of SQL run statements in same program

Getting confused by the FM...

New RPG interactive application that allows user to specify selection of
data, and am using SQL w/ PREPARE to accomplish of displaying results back
to user.  User may choose to reselect any number of times.  Since I need to
run different iterations of the SQL statement, do I need to do anything
special to "drop" the previous SQL cursor before I can do the next one?
Maybe C
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.