Using [NOT] RECORD filename EXISTS

[Deskin, Bob]

Assuming you have something like

ACCESS x LINK TO abc OPTIONAL

it should depend strictly on which is more likely to occur. There is no
initialization of a define before evaluation (that I know of). But the
DEFINE must be evaluated regardless of whether the record is there or not.
However, as Matt says (Hi Matt), you probably wouldn't notice the
difference.

This is much more important in a SELECT or SELECT file IF and in a more
complex ACCESS statement, where the sequence can make the difference in how
things are read.

Bob Deskin              
PowerHouse Web Product Manager and Senior Product Advisor
Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
 

-----Original Message-----
From: Robert J.M. Edis [mailto:robert.edis@creatcomp.com]
Sent: July 17, 2000 5:37 PM
To: 'powerh-l@list.swau.edu'
Subject: Using [NOT] RECORD filename EXISTS


G'day all

Can anyone tell me which is more efficient and results in better
performance, if at all, of the following syntax options please?


DEFINE d_xyz CHAR*1 = "Y" IF RECORD abc EXISTS ELSE "N"

Vs.

DEFINE d_xyz CHAR*1 = "N" IF NOT RECORD abc EXISTS ELSE "Y"

Regards,

Blue
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.