Re: Doohickey to visually show relationships between files

[vhamberg@xxxxxxxxxxx]

MS Access has a relationship diagram function. It is limited but I don't 
remember by what. You can use it against links, which will not actually 
download anything to the PC. You add tables and drag-drop to show the common 
keys. Still manual work, of course.

-------------- Original message -------------- 

> Yes, iSeries Navigator does an outstanding job. PROVIDING YOU USE 
> REFERENTIAL CONSTRAINTS. I'll send you a PowerPoint offlist. 
> 
> Rob Berendt 
> -- 
> Group Dekko Services, LLC 
> Dept 01.073 
> PO Box 2000 
> Dock 108 
> 6928N 400E 
> Kendallville, IN 46755 
> http://www.dekko.com 
> 
> 
> 
> 
> 
> "Frances Denoncourt" 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx 
> 05/05/2005 02:26 PM 
> Please respond to 
> Midrange Systems Technical Discussion 
> 
> 
> To 
> 
> cc 
> 
> Subject 
> Re: Doohickey to visually show relationships between files 
> 
> 
> 
> 
> 
> 
> I'd like a doohickey similar to the original post - but, more. 
> [Original post: So I guess I'm looking for a tool that allows me to plug 
> in file names 
> which, in turn, lists fields defined, and perhaps "click & drag" 
> connectors 
> that show relationships as I discover them.} 
> 
> Many months ago I started entering files into a VISIO document. Quite 
> labor intensive. Just a file or two now and then. 
> Now that we are going to Visual Studio, I wish I had put more time into 
> it. It looks like I can import a schema into VISIO, but where would I 
> get it? 
> 
> I could use Enterprise Manager to create a diagram, but the problem is 
> still: How can I get the information from each file on our iSeries in a 
> format that this diagrammer can interpret? I sure don't want to start 
> keying all over again. 
> 
> Does iSeries Navigator do something like that? I don't care which one I 
> use as long as I can get something to paper my wall with. Exporting to 
> the Enterprise Manager diagrammer would be much, much better, though. 
> 
> 
> [Another post: Yes, take a look at the "Database Navigator" in the 
> Database section of iA 
> 
> Probably won't do what the original poster wants since to show the 
> referential links between tables you have to actual have referential 
> keys 
> defined.] 
> 
> Thanks for your help 
> 
> Fran Denoncourt 
> Sr. Programmer/Analyst 
> Pinal County Treasurer's Office 
> Florence, AZ 85232 
> (520) 866-6404 
> 
> Receipt of this message does not grant you permission to send me 
> Unsolicited Commercial Email 
> 
> -- 
> 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. 
> 
> 
> -- 
> 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. 
>