For UniVerse users, remember those handy pseudo-attributes 9998 and 9999. Regards
JayJay Sent from my iPad On 4 Sep 2012, at 18:18, "Morelli, David W." <dmore...@pacificu.edu> wrote: > LEN(@RECORD) is a sufficient answer to the underlying question. I had > remembered "LEN" and couldn't recall the "@RECORD". > > Thank you. > > David > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson > Sent: Friday, August 31, 2012 4:49 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Friday type of question > > In the DICT, in an I-descriptor you can specify LEN(@RECORD) If the record > has zero length it's empty. > > > > > > > > > -----Original Message----- > From: Morelli, David W. <dmore...@pacificu.edu> > To: U2 Users List <u2-users@listserver.u2ug.org> > Sent: Fri, Aug 31, 2012 4:42 pm > Subject: [U2] Friday type of question > > > Is there an easy way to determine if a record is empty? > > I have a saved list of a thousand or more records that have record ID's that > interfere with our Ellusian database. > > If they are truly empty, I can do house cleaning on them. If they contain > any data, I have to do a different process. > > When I AE into a record I get > :AE PERSON 2362 > Top of "2362" in "PERSON", 0 lines. > > So, it is really empty. > > I believe there must be a better way than handling every one of them, but I > have been away from Unidata and forgotten everything. > > David Morelli > Pacific University > Oregon > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users