existence checking

manish raj kr

existence checking
Esteem list,
I am looking for the situation where the “Existence checking” is used in
application program using DB2.
Will appreciate any code/SQL or any article as pointer.

Thanks,
Manish



Dominic MORTIMER

Re: existence checking
(in response to manish raj kr)
Manish,

One quick way of doing it would be

EXEC SQL
SELECT 1 FROM xxx.yyy
WHERE aaa=bbb
END EXEC

And then test the SQLCODE.

Cheers

Dom

-----Original Message-----
From: Kr Manish [mailto:[login to unmask email]
Sent: 03 January 2003 08:42
To: [login to unmask email]
Subject: existence checking


Esteem list,
I am looking for the situation where the "Existence checking" is used in
application program using DB2.
Will appreciate any code/SQL or any article as pointer.

Thanks,
Manish



http://listserv.ylassoc.com. The owners of the list can be reached at
[login to unmask email]


_________________________________________________________
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received
this email in error and that any use, dissemination, forwarding, printing,
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.
_________________________________________________________