× 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.



Our company is starting a project to develop a new generation of
applications written in Java. The problem arises with the databases living
on the AS/400.

The developer is using a Google tool to create the databases but that
creates a problem because the tables and field names are being created with
default names if the name is greater than 10 characters.

We want the databases to be meaningful from the AS/400 side (Meaningful
short names for tables and field names, Consistent record format names).

The way I have handled this in the past is to create the table using Ops Nav
and extract the SQL to create and change tables but that means doing changes
manually where the tools do it automatically.

Anybody got any suggestions on how you handled this problem? Do you know of
a tool that would deal with the AS/400's unique requirements (A long and
short name, format names, etc)?

Thanks in advance for any help.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.