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
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
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
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
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
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
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
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
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:
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@
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
11 matches
Mail list logo