Re: Embedded SQL: 6 views of data, 6 identical cursors, excepting the Where clause

I would define my sql statement in one string str1 at least up to the where clause where I guest everything is the same for the 6 views, add one more string str2 and change it accordingly for each where clause, then concatenate both string before declare cursor and prepare my cursor from the final string str3=str1+str2. I dont know if needed but you could even use parameters marker like for example:  where fld1=?
--
Sent from Mail.Ru app for Android Friday, 05 February 2016, 01:00AM -05:00 from Booth Martin < booth@xxxxxxxxxxxx> :

A large file, with 6 views over the file. The requirement is to use SQL
to get the same data, grouped and ordered in the same way, from the file
excepting with a different Where clause. Moving the Where clause from
the Declare Cursor to the Fetch Cursor would reduce a lot of redundant
code. Is there a way to do that or similar?
--
This is the RPG programming on the IBM i (AS/400 and 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 .

Please contact support@xxxxxxxxxxxx for any subscription related questions.