×
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.
Since you are interested in migrating this to off platform, then I'll
assume it's fair to say that these people have some familiarity with
systems other than IBM i, true? Hopefully that includes other databases?
Well, then they should feel right at home with IBM i. Because they could
query the system catalog to get a list of all columns in all tables, a
list of all tables, a list of all members in all files, a list of all
views, indexes, etc.
All they have to do is to use ODBC to connect to library QSYS2 and query
things like SYSCOLUMNS, SYSTABLES, SYSVIEWS, SYSINDEXES and more. No need
for DSPFFD, DSPFD, and all that rot.
And if they are tired of the character based interface sometimes used on
other platforms then they're going to love the graphical interface
available on the IBM i. Have them try the iNav interface for all this.
"IF" (and I know that's a hell of a big "if") you set up your tables with
referential integrity then the data diagramming is pretty darn good.
They can also use ODBC to move the data down to their platform of choice.
Rob Berendt
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.