ACS RSS JDBC settings need a JOBD option or a way to alter the current library

When connecting to the IBM server from any source the user account used uses its associated *JOBD to create an initial job library list. The libraries included are SYS, PRD and CUR library list portions. However, the JDBC settings only control the USR portion. I use a specific *JOBD that loads my developer library to the list in the CUR position. If I want to test SQL scripts against another set of libraries, I cannot create a JDBC setup that will remove my library from the CUR position.

Allowing for the specification of a *JOBD on the connection setup would be better as we can use existing *JOBDs that we apply to users / service jobs to mimic environment setups.

I have other ways to create proper library environment setups but they are tedious when resetting the SQL session connection using CTRL+F11.

Applying a JDBC setup then resetting the connection using CTRL+F11 reuses the last applied JDBC setup.

Create a JOBD that includes a library you dont want to use for SQL query work. Apply the JOBD to your user profile. Connect to your server and run this SQL, "select * from LIBRARY_LIST_INFO ;". You will see the library for your current library listed.

Now create or alter a JDBC setup and specify a different library list. Clear the input with "Default SQL Schema" and paste your comma separate library list into "Library List". Click Save. Note, doing this causes the first library in the list you pasted to become the Default SQL Schema, sometimes.