RE: Database design question -- MIDRANGE-L

Subject: RE: Database design question
From: Bob Cagle <bcagle@xxxxxxxxxxx>
Date: Mon, 28 Aug 2017 17:24:14 +0000
List-archive: <http://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

-----Original Message-----
From: Rob Berendt

I'd have to see that second rule in context and with further explanation.
Like, where did you get that from? Until I see that I'll hold off on judging it.

It was from a series of four IBM Systems Magazine articles from 2013 written by Jim Ritchhart.

Towards the end of the fourth article, he lists the best practices that his shop came up with:

http://ibmsystemsmag.com/ibmi/developer/modernization/dbmodernization_part4/?page=2

That being said, I have seen the same Primary vs. Unique key recommendation in other places around the web as well.

Thanks
Bob Cagle
IT Manager
Lynk

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

RE: Database design question , Rob Berendt

This mailing list archive is Copyright 1997-2025 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.