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/
