|
Frances, Two SQL APIs spring to mind: Generate Data Defintion Language, which will store the SQL statement (for creating the object type you want it to generate) in a source PF; an object type can be a table, index, view or scheme (among others). This is not such a difficult API. Ted Holt wrote a utilty on this API sometime ago at www.itjungle.com. Perhaps the result can be used on the "reverse engeneering" option of Visio. Visual Explain API, which I only come across seaching the InfoCenter (when/if it functions) and had a quick look at it; i think it is not that easy to use. Regards, Carel Teijgeler *********** REPLY SEPARATOR *********** On 5-5-05 at 12:26 Frances Denoncourt wrote: >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.
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.