|
midrange.com
Munsters.
And several sites referencing that address (search results from Google)
are blocked by our internet software. Must be popular with the porn or
satanic fellows. I expect the porn police here to come tapping me on the
shoulder any minute now...
Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin
"Bill Hopkins" <BHopkins@xxxxxxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/19/2003 02:14 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc
Subject
RE: the idea of unique primary keys to be a solution that has out lived
its usefulness?
I know I should not reply to this but no Addams Family had three addresses
in show.
001 Cemetery Lane - Greenbriar and Woodlawn, and 001 North Cemetery
Drive - Greenbriar
No state, cities made up.
And please do not ask why this is one of those things that got stuck in my
brain. Of course now that it got brought up it will take a while to
repress again. lol
Feel stupid for knowing , lol again:)
Bill Hopkins
"David Rittenberg" <DRittenberg@xxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/19/2003 01:59 PM
Please respond to RPG programming on the AS400 / iSeries
To: rpg400-l@xxxxxxxxxxxx
cc:
Subject: RE: the idea of unique primary keys to be a
solution that has out lived
its usefulness?
Wasn't it the Addams family who lived at 1313 Mockingbird Lane?
-----Original Message-----
message: 4
date: Wed, 19 Nov 2003 10:38:11 -0600
from: "Bob cozzi" <cozzi@xxxxxxxxx>
subject: RE: the idea of unique primary keys to be a solution that
hasoutl ived its usefulness?
There's something munsterously familiar about that address, hmmm?
Bob Cozzi
Cozzi Consulting
www.rpgiv.com
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, November 19, 2003 10:16 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: the idea of unique primary keys to be a solution that hasoutl
ived its usefulness?
I would think the join of compound keys would only be a poor
implementation without the use of identity columns.
Let's take this for example
Cust Address
12345 1313 Mockingbird lane
12345 500 Easy Street
56765 232 Clark Street
And then this
Cust Address Call timestamp clob field of
discussion
12345 1313 Mockingbird lane 11-03-2003-08.30.00 No answer
12345 1313 Mockingbird lane 11-03-2003-10.15.37 Bought $1,000,000
worth of new rpg development
Then if you need to change the address you have to remember to change both
files. Granted, if you use a referential constraint with CASCADE it might
do it for you. But people who program in RPG are loathe to let the system
do anything for them automatically if they can do it manually. Therefore
instead they would add a second field to both of these files that sequence
the address for that customer. Therefore it becomes:
Cust Address# Address
12345 001 1313 Mockingbird lane
12345 002 500 Easy Street
56765 001 232 Clark Street
And then this
Cust Address# Call timestamp clob field of discussion
12345 001 11-03-2003-08.30.00 No answer
12345 001 11-03-2003-10.15.37 Bought $1,000,000 worth of new
rpg development
Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin
"DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/19/2003 10:53 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
To
"'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
cc
Subject
RE: the idea of unique primary keys to be a solution that hasoutl ived its
usefulness?
Joep,
Yes, I'll agree that compound keys can indeed be considered primary keys.
I
misspoke; I was thinking of "identity columns" which are commonly used in
databases as primary key.
The difference between the two designs, imo, is that the widespread use of
compound keys makes for inefficient joins between tables.
Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863
-----Original Message-----
From: Joep Beckeringh [mailto:joep.beckeringh@xxxxxxxxxx]
Sent: Wednesday, November 19, 2003 2:47 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: the idea of unique primary keys to be a solution that
hasoutl ived its usefulness?
----- Original Message -----
From: "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
Sent: Monday, November 17, 2003 10:24 PM
Subject: RE: the idea of unique primary keys to be a solution that hasoutl
ived its usefulness?
> Unique primary keys are not what most of us use on the iSeries. We use
> unique compound keys, where the combination of many factors (keys) work
> together to define a unique row. Unique primary keys are a single field
> that describes a unique row. These are commonly implemented as UUIDs,
or
> possibly as auto-incrementing value for such things as order number and
> whatnot...
Who says so? Primary keys can be compound.
>From 'A Guide to the SQL Standard' (C.J. Date / Hugh Darwen):
In SQL, a candidate key definition takes the form
{ PRIMARY KEY | UNIQUE } ( column-commalist ).
For a given base table, at most one candidate key definition can specify
PRIMARY KEY.
Joep Beckeringh
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
