Problem with an SQL View that has selects/omits

I've just isolated a problem that's occurring with SQL views that have 
selects/omits, but NOT with DDS logicals that have functionally the same 
selects/omits.

It seems that we have a call equivalent to an RPG SETLL, followed by one 
equivalent to an RPG READ.

If that SETLL-equivalent is for a record that is omitted, it fails. On 
the DDS logical, we're able to recover, but not on the SQL view. On the 
SQL view, we blow up with an MCH1825 and a CPF5147

Any idea what could be wrong?

(I could be more specific, but I wouldn't want to be obligated to kill 
the entire List.) ;-)

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