Thanks Jeff!
From: Jeff Butera <jbut...@hampshire.edu>
To: u2-users@listserver.u2ug.org
Date: 04/06/2012 09:28 AM
Subject: Re: [U2] Unwanted Duplicated
Sent by: u2-users-boun...@listserver.u2ug.org
On 04/06/12 09:10, Greg Coelho wrote:
> John,
>
> Thanks for the response. I on UniData. I was thinking that perhaps
this
> was the result of a UDT.OPTION setting... Oh! I think I've just come
> across the answer - please see below:
>
> When performing a SELECT statement that employs the SAVING UNIQUE
keyword
> against a multi-valued field - the resulting list will contain two
> valuemarks on each line with a number in between after the saved value.
An
> example is useful to demonstrate:
>
> :SELECT STUDENT.TERMS SAVING UNIQUE STTR.STUDENT.ACAD.CRED SAMPLE 100
> SAVE.LIST LIST.TEST
> :AE SAVEDLISTS LIST.TEST000
> Top of "LIST.TEST000" in "SAVEDLISTS", 345 lines, 4,093 characters.
> 001: ý1ý1
> 002: 1003926ý1ý1
> 003: 1003927ý2ý1
> 004: 1003928ý3ý1
> 005: 1024941ý1ý1
> 006: 1024942ý2ý1
> 007: 1024943ý3ý1
> 008: 1036527ý1ý1
> 009: 1036528ý2ý1
> 010: 1036529ý3ý1
Correct - this is normal behavior. The way to remove these is to
GET.LIST and then perform a select against the file for which these are
keys and save it again.
We dealt with this years ago in a similar situation.
So you would followup with
GET.LIST LIST.TEST
SELECT STUDENT.ACAD.CRED
SAVE.LIST LIST.TEST
and your list will now be free of the @VM garbage.
--
Jeff Butera, Ph.D.
Manager of ERP Systems
Hampshire College
jbut...@hampshire.edu
413-559-5556
"...we must choose between what is right and what is easy..."
Dumbledore
_______________________________________________
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
