Question

How do I control the library list that is in affect on the remote system using SQLPKG?

iSeries, SQLPKG, Remote access, library

In using SQLPKG, I believe my program is running blind on the remote system. How do I control the library list that is used when the SQLPKG is run?

Hi,

The library list comes from the user profile's job description of the user you connect with. If you need to change it, you can use an SQL CALL to run a program to execute the CHGLIBL command.

Or, you can use the DFTRDBCOL and SQLPATH keywords on the CRTSQLRPGI command if you're using SQL naming conventions and SQL functions and procedures.

Rick