Re: Doohickey to visually show relationships between files

Jack,

Has nothing to do with IBM, and everything to do with us, and the software 
vendors.

IBM has given us the tools with DDS and ADDPFCST.  IBM has given us the 
tools with SQL and the CONSTRAINT keyword.  IBM has given us the GUI tools 
with iSeries Navigator.  We just have to use them.  To insist otherwise is 
like the user who wants an accurate MRP report but doesn't want to key in 
any inventory transactions.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Jderham2@xxxxxx 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
06/30/2004 04:51 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Fax to

Subject
Re: Doohickey to visually show relationships between files






In a message dated 6/30/2004 5:15:27 PM Eastern Daylight Time, 
WaldenL@xxxxxxxxxxxxxxx writes: 
> Jack,
> 
> DSPFD, DSPFFD and DSPDBR are all fine and dandy when you want to know
> something about a single table, but when you want to know about the
> relationships _between_ tables, you need something more. 
> 
> Perhaps you can keep all the relationships in you head, but on systems
> with several thousand tables I know I don't recall them all. To be able
> to select a single table and see all the "related" tables is invaluable.
> Add to that the ability to select table A and table F and visually see
> the way to get from A to F is great!
> 
> DSPFD, FFD and DBR are great tools, but the world has evolved, it's time
> for the iSeries community to do the same. 
> 
Walden,
You are 100% correct with regards to the iSeries needing to evolve but I 
think the members of our community would get more results aiming there 
efforts at 
IBM to make them require or better allow for any file relationships to be 
defined within the context of the DDS or now the SQL definitions rather 
then 
leaping onto the Microsoft band wagon to solve our problems.

The concepts of a schema have been around for a very long time so all we 
have 
got to do together is push IBM off of the "seat down the hall"

Jack Derham
Direct Systems, Inc.
Marietta, GA
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.