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