Re: 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?

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
http://www.linkedin.com/in/dennislovelady
--
"You'll never make it - four-groups are out.  Go back to Liverpool."
        -- Decca Records executive to the Beatles in 1962


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