I'd recommend the same, but I'd use READNEXT instead of @SELECTED so there isn't a list floating around waiting to be used.
EXECUTE 'SELECT filename SAMPLE 1' READNEXT DUMMY THEN EMPTY = 0 ELSE EMPTY = 1 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MICHAEL MR Sent: Monday, November 29, 2004 3:17 PM To: [EMAIL PROTECTED] Subject: Unclassified RE: [U2] Testing if a Unidata file has records or not! Frank, I wouldn't do it that way! If the file actually has a gazillion records in it, "COUNT" could take a l-o-n-g time! ;-) Another way could be to do EXECUTE 'SELECT <file name> SAMPLE 1'. IF @SELECTED EQ 0 THEN <the file is indeed empty> END ELSE <the file is not empty> END [This is the UniVerse syntax, but UDT should be similar] HTH Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bright, Frank Sent: Tuesday, 30 November 2004 10:38 To: U2-Users Group (E-mail) Subject: [U2] Testing if a Unidata file has records or not! To All: I am writing an interesting program. One that finds where a file is empty of records or not. I used the EXECUTE command with the COUNT command to get the number of records in a file. If its 0 then the file is empty. But is there a better way as the execution command causes problem in other parts of this program. So, if anyone has any ideas along the lines of telling if a file is empty (Unidata file), could you please give me a note! Thank You Very Much! Frank Bright Univ. of the Arts [EMAIL PROTECTED] ___________________________________________________ Frank M. Bright [EMAIL PROTECTED] Administrative Computing University of the Arts (A15) http://www.uarts.edu 320 S. Broad St. 215-717-6081(w) Philadelphia, PA 19102 215-717-6087(f) Colleague 17.0.14 AIX 5.2.0.2 Unidata 6.03 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/