Although I have seen most of the "Unique ID' scenarios that
were presented, there is one that has been missed. I have
seen keys that appeared identical but had one or more trailing
spaces. They appeared unique to the untrained observer. AND
this could happen with a SQL database, also if the key
se 4 old-school systems.
My 1 cent.
- Original Message -
From: "Kathleeni M Bodine" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 08, 2005 2:34 PM
Subject: RE: [U2] Unique Ids
> The person who had the comment has worked in the MV world for how long.
>
>
If you in this situation do a separate select followed by a list
statement instead then
one of the two records will be listed twice ! ( I.e. if both records
meet the selection criteria ..)
This is because the select list will only conatin keys and the list
will use the
partitioning algorit
On SQL and UV tables (I don't know about UD) indexes (secondary keys) can
be specified with a unique constraint. If the person was thinking about
files indexes, their statement may be correct as you cannot specify the
unique constraint on UV "file" indexes.
Regards,
Stuart Boydell
[EMAIL PROTECTE
The non-unique keys may also be called an index --> quite OK to have an index
on a date field & have multiple records on the same day.
Would have to be read in context of the meeting
Ross Ferris
Stamina Software
Visage an Evolution in Software Development
>-Original Message-
>From: [
I'm glad I read through the rest of the messages before replying. Thank you
Ron for the explanation on my behalf.
- Original Message -
From: "Pingilley, Ron" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 08, 2005 4:33 PM
Subject: RE: [U2] Unique Ids
David,
If yo
me) had a Mn.x structure
defining Master Value (n) and x(the controled subvalue positions)
of coures if you weren't talking about that .. ignore
dsig
> Original Message --------
> Subject: Re: [U2] Unique Ids
> From: "Geoffrey Mitchell" <[EMAIL PROTECTED]&
You can do it with a Universe SQL table (Make MV values unique, that is).
In traditional UV tables, however, you are correct. The uniqueness in
this case is a combination of the primary key and the MV position.
I would also guess that the person in question was referring to
multivalues since tr
eport.
Good catch, Jerry!
--Ron P.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 4:14 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unique Ids
How would you 'create' the part file to begi
are 'typed' except for the inclusion of a 'variant'
type .
DSig
David Tod Sigafoos
SigsSolutions, Inc.
> Original Message --------
> Subject: RE: [U2] Unique Ids
> From: "Bob Woodward" <[EMAIL PROTECTED]>
> Date: Tue, March 08, 2005 12:41
s
SigsSolutions, Inc.
> Original Message --------
> Subject: Re: [U2] Unique Ids
> From: "Jerry Banker" <[EMAIL PROTECTED]>
> Date: Tue, March 08, 2005 1:48 pm
> To: u2-users@listserver.u2ug.org
>
> Now you could have a situation where y
David,
I just came out of a meeting where it was stated that MV databases allow
non-unique keys.
perhaps the person was refering to multivalues?
If you were modelling parents and children in an SQL database you might
use a PARENTS table and a CHILDREN table. Usually neither table would
allow dupl
Now you could have a situation where you brought a part file online that had
a duplicate key.
- Original Message -
From: "Bob Woodward" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 08, 2005 2:41 PM
Subject: RE: [U2] Unique Ids
I often wonder about SQL.
BobW
Lynch
F.W. Davison & Company, Inc.
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 08, 2005 3:25 PM
Subject: RE: [U2] Unique Ids
> Susan,
>
> This is the approach I took with the speaker. There was a period of
> time 'in the good old days
e out ok. I guess the SQL crowd doesn't care of
the general illogic of it, just that regular people can't use the tools.
Job security is not all bad. :-)
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> [EMAIL PROTEC
I often wonder about SQL.
BobW
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
> Sent: Tuesday, March 08, 2005 12:26 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Unique Ids
>
>
Susan,
Did you used to work for Sequoia.
George R Smith
Programmer / Analyst
479.684.3382 direct
479.684.3403 fax
www.budgetext.com
CONFIDENTIALITY NOTICE: The materials in this electronic mail transmission
(including all attachments) are private and confidential and are the property
of
e benefits of MsSql Server and the wonders of sql ..
DSig
David Tod Sigafoos
SigsSolutions, Inc.
> Original Message ----
> Subject: Re: [U2] Unique Ids
> From: "Susan Lynch" <[EMAIL PROTECTED]>
> Date: Tue, March 08, 2005 11:54 am
> To: u2-users@list
-users@listserver.u2ug.org
Subject:RE: [U2] Unique Ids
thanks for the early replies ..
it is good to know that i have not been wrong for the last 20 years
.. well at least in this instance
DSig
David Tod Sigafoos
SigsSolutions, Inc.
> Original Message
> Subje
I can't speak to your twinkie habit, but unique primary keys are built into
the design of MV databases. You couldn't have a non-unique primary key even
if you wanted one. It's possible that with certain kinds of file
corruption, you could get a record that for some reason hashed into the
wrong gr
Indexes don't have to be unique. Is that what they were referring to ?
Anthony
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 1:38 PM
To: U2 Users List
Subject: [U2] Unique Ids
I just came out of a meetin
ks,
Marilyn A. Hilb
Value Part, Inc
Direct: 847-918-6099
Fax: 847-367-1892
[EMAIL PROTECTED]
www.valuepart.com
-Original Message-
From: Kathleeni M Bodine [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 1:35 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Un
thanks for the early replies ..
it is good to know that i have not been wrong for the last 20 years
.. well at least in this instance
DSig
David Tod Sigafoos
SigsSolutions, Inc.
> Original Message
> Subject: RE: [U2] Unique Ids
> From: "Allen E. Elwood"
From: <[EMAIL PROTECTED]>
Sent: Tuesday, March 08, 2005 1:37 PM
> I just came out of a meeting where it was stated that MV databases allow
> non-unique keys.
Secondary keys perhaps, if you're considering the indexes as keys, but not
the primary key. Primary keys are by definition unique. Unl
ECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood
Sent: Tuesday, March 08, 2005 2:12 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unique Ids
Hi David,
It ain't so Joe!
All keys must be unique.
If I have a record with the ID of JoeItAintSo and I try to add another
record wit
The only time I've seen duplicate key values in UniVerse files is when the file
has become corrupted. I suspect that doesn't fall into the assertion made in
your meeting, which is just plain wrong. Hashing algorithms wouldn't be as
effective as they are if duplicate key values were allowed.
--
I don't recall an MV implementation that intentionally allowed non-unique
primary keys. Were the people in the meeting thinking of secondary keys
(aka indexes) in which non-unique keys are quite possible?
The only other thing I can think of would be the old (and non-intentional!)
problems with tr
The person who had the comment has worked in the MV world for how long.
The only time I have seen this was when a file was corrupted.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 10:38 AM
To: U2 Users Li
Well certainly you have have two records with the same ID, but only if
there is more than a single file in play. I can have record X in both
file A and file B, but I cannot have a record with a key of X twice in
file A without some file corruption.
There is uniqueness within a single file, but no
Hi David,
It ain't so Joe!
All keys must be unique.
If I have a record with the ID of JoeItAintSo and I try to add another
record with the same key, it will just overwrite the original record. I can
have JoeItAintSo, JoeItAintSo1, JoeItAintSo2, etc., that works, maybe that
was what they were th
30 matches
Mail list logo