RE: Best Practices on DB2 SQL Databases

Alan,

Does the tool have an alias value? Maybe you could put the short names in there. You probably already know this but the syntax to have both long and short names is like this.

Create table Table_Name (Long_Name for Short_Name Char(10), ... )

Maybe the SQL can be tweaked after it is created. That may not work going forward if the tool is used on the file later though.

Rick

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

Privileged and Confidential. This e-mail, and any attachments there to, is intended only for use by the addressee(s) named herein and may contain privileged or confidential information. If you have received this e-mail in error, please notify me immediately by a return e-mail and delete this e-mail. You are hereby notified that any dissemination, distribution or copying of this e-mail and/or any attachments thereto, is strictly prohibited.