Control the Library List from a SQL Server Linked Server Definition
July 23, 2008 Hey, Mike
We are having more and more users call AS/400 jobs from a SQL Server session on their PCs, and we have trouble giving them the proper library list. Usually, just giving them the libraries in QUSRLIBL works fine. Is there a way to make sure every user, regardless of originating machine or system, gets the library list values of QUSRLIBL?
I’m guessing that you’re using the SQL Server’s linked server facility to connect to the AS/400. If so, the first thing you need to do is check the linked server’s data provider. SQL Server will use either an