db2 get connection state - its a DB2 command, not SQL, so you'll have
to parse the output into a variable or suchlike.

-----Original Message-----
From: Blair Jensen
[mailto:db2udbdba-ezmlmshield-x79282313.[Email address protected]
Sent: Friday, 29 April 2005 8:09 AM
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."
========================================================================
======



NOTICE
This e-mail and any attachments are confidential and may contain copyright material of Macquarie Bank or third parties. If you are not the intended recipient of this email you should not read, print, re-transmit, store or act in reliance on this e-mail or any attachments, and should destroy all copies of them. Macquarie Bank does not guarantee the integrity of any emails or any attached files. The views or opinions expressed are the author's own and may not reflect the views or opinions of Macquarie Bank.


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