Re: SQLPKG access from mulitple IBM i clients

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

what is the method to get to these remotely IP DDM??


On Wed, Aug 14, 2013 at 8:53 AM, Paul Therrien <
paultherrien@xxxxxxxxxxxxxxxxxx> wrote:

> I am creating an SQLRPGLE program that accesses a remote IBM i database.
> I create the SQLRPGLE program on my test IBM i.  I create the SQLPKG on
> the remote server from m test box.  I can access the remote server via
> the SQLPKG via my SQLRPGLE program - not a problem.
> I now move my program to the a 3rd staging IBM i machine and I want to
> access the same SQLPKG on the same remote box as before. But on the
> staging box I am getting SQL error -805 - SQLPKG not found.  The SQLPKG
> is there when I look at the object via WRKOBJ.
>
> I have many questions, but here are the 1st 2:
> 1.  Do I need to recreate the SQLPKG on the server machine from the
> staging box in order to run my program on the staging box?
> 2.  Is there a way to create a generic SQLPKG that can be accessed from
> multiple IBM i clients?
>
> Thanks for your help.
>
> Paul
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.