One quick way of doing it would be
SELECT 1 FROM xxx.yyy
And then test the SQLCODE.
From: Kr Manish [mailto:[login to unmask email]
Sent: 03 January 2003 08:42
To: [login to unmask email]
Subject: existence checking
I am looking for the situation where the "Existence checking" is
application program using DB2.
Will appreciate any code/SQL or any article as pointer.
owners of the list can be reached at
[login to unmask email]
This email is confidential and intended solely for the use of
individual to whom it is addressed. Any views or opinions presented
solely those of the author and do not necessarily represent those
If you are not the intended recipient, be advised that you have
this email in error and that any use, dissemination, forwarding,
or copying of this email is strictly prohibited.
If you have received this email in error please notify the
SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.