[U2] Friday type of question

2012-08-31 Thread Morelli, David W.
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

Re: [U2] Friday type of question

2012-08-31 Thread Wjhonson
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. To: U2 Users List Sent: Fri, Aug 31, 2012 4:42 pm Subject: [U2] Friday type of question Is there an easy way to determine

Re: [U2] Friday type of question

2012-08-31 Thread Rutherford, Marc
nalyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Morelli, David W. Sent: Friday, August 31, 2012 4:43 PM To: U2 Users List Subject: [U2] Friday type of question Is there an easy w

Re: [U2] Friday type of question

2012-08-31 Thread Allen Elwood RR
ust 31, 2012 4:43 PM To: U2 Users List 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 clea

Re: [U2] Friday type of question

2012-08-31 Thread Wjhonson
boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Morelli, David W. > Sent: Friday, August 31, 2012 4:43 PM > To: U2 Users List > Subject: [U2] Friday type of question > > Is there an easy way to determine if a record is empty? > > I h

Re: [U2] Friday type of question

2012-09-01 Thread Israel, John R.
e value mark, still has a length of 1. > > > > > > > > -Original Message- > From: Allen Elwood RR > To: U2 Users List > Sent: Fri, Aug 31, 2012 8:29 pm > Subject: Re: [U2] Friday type of question > > > > does that still work if t

Re: [U2] Friday type of question

2012-09-01 Thread Wjhonson
That's correct, it's not empty and the length is non zero. The dict item has to be compared to zero to determine that it exists and is empty both -Original Message- From: Israel, John R. To: U2 Users List Sent: Sat, Sep 1, 2012 8:06 am Subject: Re: [U2] Friday type o

Re: [U2] Friday type of question

2012-09-01 Thread Charles Stevenson
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 in

Re: [U2] Friday type of question

2012-09-04 Thread Morelli, David W.
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. To:

Re: [U2] Friday type of question

2012-09-04 Thread John Jenkins
uldn'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@

Re: [U2] Friday type of question

2012-09-04 Thread Wjhonson
ED DICT &SAVEDLISTS& LEN 001 D 002 003 004 005 5R 006 S -Original Message- From: John Jenkins To: U2 Users List Cc: U2 Users List Sent: Tue, Sep 4, 2012 11:58 am Subject: Re: [U2] Friday type of question For UniVerse users, remember those handy pseudo-attributes