RE: Record seach options - millions of records

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden H. Leverich
Sent: Wednesday, May 02, 2007 3:11 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Record seach options - millions of records

Note that if you are using EXISTS, the fields in the select clause

don't matter.

True. However, DB2/400 doesn't allow a select w/out the from
clause, so you can't just check for exists(), you need to
select from somewhere where exists()... So now you've
introduced another table.

Ideally you should be able to do:

Select 1 where exists(select * from xxx where ...)

There are many times you're just checking for existence.
However, we need to do a:

Select 1 from sysdummy where exists(selct * from xxx where...)

And now that's just getting ugly.

Naw, that's not so bad.

You want ugly????

Try getting a 1 back if something exists but a zero (instead of null) if
something doesn't ;-)


Charles

This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are not a
named addressee you are hereby notified that you are not authorized to read,
print, retain, copy or disseminate this communication without the consent of
the sender and that doing so is prohibited and may be unlawful. Please reply
to the message immediately by informing the sender that the message was
misdirected. After replying, please delete and otherwise erase it and any
attachments from your computer system. Your assistance in correcting this
error is appreciated.