My practice has been to use the long names exclusively. Using database
design tools, I can make sure the long name is meaningful. I let DB2400
generate the short names, then rename to something meaningful if I need
to use the table in some "native" way.
DB2400 will generate almost meaningless short names. By "almost", I
refer to the practice that it will retain the first four or five
characters of the long name when it generates the short name. Those few
characters are sometimes all you need to make the short name meaningful.
If I NEED to use an SQL-generated table in an RPG program (or anything
else that needs short names) I'll change the short names with an ALTER
to something meaningful. I don't have to do that very often. Usually the
tables I design for my Java apps are used only by my Java apps.
Occasionally, though, I need to call an RPG or CL program from Java and
have that program read a table. I'll ALTER that table with meaningful
short names.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Tuesday, January 13, 2009 4:40 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Best Practices on DB2 SQL Databases
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.
--
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.
midrange.com
