Passing User Names as parameters in ProC

I need to compile my code against several different users. Everytime I switch users, I need to "manually" change this is my code (e.g. select * from user1.table needs to be changed to select * from user2.table, etc.). Is there anyway to pass this as a parameter into my routine? I know that I can pass the username and password to the connection string, but I have not figured out a way of passing it in as a host variable. Received on Wed Jul 02 1997 - 00:00:00 CDT