Re: Problem with an SQL View that has selects/omits

I've now got an MI implementation of the "iteratively SETLL until a 
record (or EOF) is found" in the initial testing stage, but I've got a 
problem.

The concept works just fine if I know the read is going to fail, and go 
straight to the iterative SETLL gambit before attempting to read a 
record, but when I actually let the READ operation fail (whether in RPG 
or in MI), the first SETLL operation throws a CPF5129 ("I/O is not 
allowed because the program device or member . . . is in error")

Anybody know how, short of closing and reopening the file, to reset that 
state?

Or does anybody know of a flag in the FIB, or the Open Feedback, or 
someplace similar, that will tell me it's an SQL VIEW instead of a DDS 
LF? It's been a few years since I was in those structures last (I think 
it was when I figured out how to do RLA reads of files containing 
SQL-only fields without crashing).

--
JHHL
_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.