Re: Embedded SQL Question

[dlclark@xxxxxxxxxxxxxxxx]

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 02/16/2017 
01:46:53 PM:
> "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 02/16/2017 
> 01:40:12 PM:
> > Program A and Program B are in DIFFERENT job streams and require to 
> fetch
> > completely different rows from the same Table.
> > They end up calling Program X concurrently (or say B calls X when 
> Program
> > A's call to X still has the Cursor open), will they end up fetching
> > incorrect rows?
>
>         No, cursor sets do not cross job boundaries.

        But, I will say this...  The only way cross-job cursor sets can 
affect each other is with locks.  So, consider the SQL isolation level 
being used for these processes.

Sincerely,

Dave Clark