If you also want to delete everything with only system delimiters but no
actual data between them do something like:
SELECT PERSON WITH EVAL "LEN( CONVERT( @AM:@VM:@SM, "", @RECORD ))"
= "0"
or
SELECT PERSON WITH EVAL "SUMMATION( LENS( @RECORD ))" = "0"
Technically, system delimiters include chars 255 thru 248 so the 2nd
form is more rigorous.
On 8/31/2012 6:42 PM, Morelli, David W. wrote:
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.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
