posted 19 years ago
I'm using WAS5.1 & DB2.
I want to set the current SQL id so that I don't have to prefix all my table names with the Table creator.
I'm thinking I could set up the Id as an environment variable and use this in a 'SET CURRENT SQLID' statement that I execute immediately prior to each applicaiton SQL statement, but..
Is there a better way to do this?
Can I set something in a config file to get WAS to use a particular SQLID for my app?
Thanks in advance,
Louise