Unix Technical Forum

"USE" statement in AS/400 DB2 SQL

This is a discussion on "USE" statement in AS/400 DB2 SQL within the DB2 forums, part of the Database Server Software category; --> anyone know an analagous statement for the "USE" statement in SQL Server T-sql? I want to use USE 'db' ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 05:06 PM
bccbccbcc
 
Posts: n/a
Default "USE" statement in AS/400 DB2 SQL

anyone know an analagous statement for the "USE" statement in SQL Server T-sql?

I want to use

USE 'db'
Select * from tblREV

instead of

Select * from db.tblREV

I am using the RUN SQL SCRIPTS from the AS/400 Operations Navigator
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-26-2008, 05:06 PM
Serge Rielau
 
Posts: n/a
Default Re: "USE" statement in AS/400 DB2 SQL

Try:
SET CURRENT SCHEMA = DB2
or
SET CURRENT SQLID = DB2

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:14 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com