"bccbccbcc" <bill.chiou@pacificlife.com> wrote in message
news:e627f7bb.0402121324.332e702c@posting.google.c om...
> 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

I am not sure about DB2/400, but look a the SET SCHEMA statement in the SQL
Reference Guide.