×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
iSeries Navigator is pretty good in this regard, though not perfect.
QSYS/QADB* xref files are probably the most accurate source.
QSYS2/SYS* SQL catalogue views are a level of abstraction on top of base
xref files.
Too bad there's no ER tool that covers all the intricacies of DDS & DDL
databases.
Elvis
Celebrating 10-Years of SQL Performance Excellence
http://centerfieldtechnology.com/training.asp
-----Original Message-----
Subject: Re: Entity Relationship Diagramming Tools
Chuck wrote: "Primary keys are not simply unique keys from the DDS created
file . . ."
Regarding unique keys of DDS-described physical files: I know that unique
keys don't on their own have primary key contraints associated with them
(unless specified with the "add constraint" cmds you mentioned). But I
think they are candidates for primary keys, and it would be nice to have an
option to specify them as primary keys. Some tools don't even reverse
engineer the unique keys as unique keys, just as regular fields.
Where can I get info regarding where the unique key specifier, and
relationships between logical and physical are stored in QSYS (QADB
catalog)?
Thanks.
*******************
Linda J. Jahn
midrange.com
