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

This doesn't belong here anyway, as this has nothing to do with MI.  Please
use the correct list.


>> 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?
> 
>Descriptions of problems are nice for as far as they go.  This one doesn't
>go far at all without supporting source.  If you need to kill anyone who
>sees the code, perhaps this is not the correct forum for this problem.
>
>Dennis Lovelady



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