View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 05:06 PM
bccbccbcc
 
Posts: n/a
Default "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
Reply With Quote