Q
Problem solve Get help with specific problems with your technologies, process and projects.

Controlling a library list on a remote system

The key to determining the library list used for SQL statements executed in a remote SQL package is found in the configuration and description of the QRWTSRVR prestart jobs that are used by DRDA connections on the AS/400.

When using SQLPKG : How do I control the library list that will be in effect on the remote system?
First the SQL program would need to be using *SYS (System) naming option to enable SQL to use the library list for unqualified references in an SQL statement. You would need to look at the configuration and description of the QRWTSRVR prestart jobs that are used by DRDA connections to determine the library list that would be used when executing SQL statements stored in a remote SQL package.
This was last published in October 2008

Dig Deeper on iSeries SQL commands and statements

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close