SQLing across machines

All of the machines that I refer to below are IBM I and running V7.3.



I have some software that I am writing for a client that will run on
multiple "client" machines and needs to update data on a "host" machine. I
have created SQL statements that "select * from system.library.file" and
"update system.library.file" but now I have found out that they want to
install this on several different host machines and each will have its own
set of clients. For example client1 and client2 will talk to host1 and
client 3 and client 4 will talk to host2. So, the system name needs to be
changed to a variable. Also, we need to make the library name variable so
we can create a test environment using a different library name.



I had thought about doing a set connection but I would have to bounce back
and forth between the client and host connects (not all data resides on the
host). That also doesn't help me with the library name variability.



So, I'm thinking that I am going to have to build SQL strings and use
"prepare" or "execute immediate" statements so I can make the system and
library variable. Is there an easier way that I am not thinking of.