"USE" statement in AS/400 DB2 SQL Anyone know if there is an analagous statement for the "USE" statement
used in SQL Server? I am trying to prevent from having to change all
the references to a database in my sql statement.
I want to do
Use 'db2'
Select * from tblRev
Instead of
Select * from db2.tblRev.
I am using the RUN SQL SCRIPTS compiler that comes with the AS/400
Operations Navigator? Please help I don't want to have to go back and
remove the test database references.
thanks |