You can do
Db2 "values current server" to get the current database name.

Regards,
Kondal R YENNARAM



-----Original Message-----
From: Blair Jensen
[mailto:db2udbdba-ezmlmshield-x79282313.[Email address protected]
Sent: Thursday, April 28, 2005 5:09 PM
To: LazyDBA Discussion
Subject: Get Database Name From SQL


Does anyone know if there is a way to get the database name that I'm
connected to from SQL?

Thanks,
Blair

========================================================================
======
"Attention: This message is intended only for the individual to whom it
is addressed and may contain information that is confidential or
privileged. If you are not the intended recipient, or the employee or
person responsible for delivering it to the intended recipient, you are
hereby notified that any dissemination, distribution, copying or use is
strictly prohibited. If you have received this communication in error,
please notify the sender and destroy or delete this communication
immediately."
========================================================================
======


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page