Re: [U2] Unwanted Duplicated

2012-04-09 Thread George Gallen
:' SAVING UNIQUE 4 SAVE.LIST GET.IMOD.ADDRESS ... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, April 06, 2012 8:48 AM To: U2 Users List Subject: Re: [U2] Unwanted Duplicated

Re: [U2] Unwanted Duplicated

2012-04-06 Thread John Thompson
If this is Universe I would say look for some option somewhere that is not set. Perhaps it behaves differently between account flavors. For example, in a BASIC program in a PICK flavor account, in order to use multiple SELECT lists you have to put $OPTIONS -x (I think) at the top on the program.

Re: [U2] Unwanted Duplicated

2012-04-06 Thread Greg Coelho
: [U2] Unwanted Duplicated Sent by:u2-users-boun...@listserver.u2ug.org If this is Universe I would say look for some option somewhere that is not set. Perhaps it behaves differently between account flavors. For example, in a BASIC program in a PICK flavor account, in order to use

Re: [U2] Unwanted Duplicated

2012-04-06 Thread Jeff Butera
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

Re: [U2] Unwanted Duplicated

2012-04-06 Thread Greg Coelho
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

Re: [U2] Unwanted Duplicated

2012-04-06 Thread Charles Stevenson
algorithm as UD or UV uses. cds On 4/6/2012 8:32 AM, Greg Coelho wrote: Thanks Jeff! From: Jeff Buterajbut...@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

Re: [U2] Unwanted Duplicated

2012-04-05 Thread Greg Coelho
Hey Guys, I am selecting SAVING UNIQUE on a multivalue field. I then MERGE.LIST these ID's with a larger group - which should itself only return Unique ID's. What I am getting returned is a sizeable number of duplicates. Looking closer it appears that these ID's are often attached to a value