Re: Issue using 3 part SQL file naming system.library.table

[DFreinkel <dfreinkel@xxxxxxxxxxxxxxxxx>]

I just soled my rookie error

I used the sql notation instead of *sys

Thanks

Sent from my iPhone

> On Oct 30, 2019, at 10:39 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
>
> I use three part naming all the time, never an issue...
>
> I think you've got something else going on...
>
> Only thing I can thing of would be some sort OVRDBF being issued in the
> remote job..
>
> Or maybe some sort of SQL Exit point program that's redirecting the SQL
> statement.
>
> Charles
>
> > On Wed, Oct 30, 2019 at 2:06 PM dfreinkel <dfreinkel@xxxxxxxxxxxxxxxxx>
> > wrote:
> >
> > I am testing a SQLRPGLE program using the 3 part table name in the SELECT
> > statement.
> >
> >
> >
> > To my surprise, The data being retrieved cam from the remote LPAR but from
> > the wrong library.
> >
> >
> >
> > 1.      Does anyone know why this is?
> > 2.      It seems to be using the jobd on the remote LPAR but I have no
> > proof.
> > 3.      How do I get it to pull the data from the library name in the
> > SELECT
> > statement?
> >
> >
> >
> > TIA
> >
> >
> >
> > Darryl Freinkel
> >
> > A4G.
> >
> > Tel: 770.321.8562 Ext 111 | Cell: 678.355.8562
> >
> >
> >
> > --
> > This is the RPG programming on IBM i (RPG400-L) mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/rpg400-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com
> -- 
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com