Re: Best Practices on DB2 SQL Databases

As I indicated in my original e-mail that is how I am doing it now for other
things.

I create the table using Ops Nav, extract the SQL, clean up and then create
the objects using my compile tool and RUNSQLSTM.

All that works except it is manual. I was hoping there was a PC based tool
that would deal with all this automatically.

As far as CL command, IBM has an API you can call that extracts the SQL from
a DDS defined table. The bizzare part is that the data it returns is a
subset of the data returned by using Ops Nav. Apparently IBM has two
different API's on the AS/400 to do the job. One called by Ops Nav and a
second called from the API.

Someone recently published a CL command that ran the API (I think Iseries
News) but like I said it only has part of the data. Using Ops Nav gives you
it all but has to be ran one by one.

On Wed, Jan 14, 2009 at 9:05 AM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

From: Walden H. Leverich
I would assume (hope/pray) that the java developers were using
some sort of ORM... so they don't really care about theDB column
names, they'll never be using them.

That kind-of begs the question - why not use SQL scripts and the RUNSQLSTM
command, or plain old DDS to define tables? Then Java developers could
tailor the ORM to their liking.

The thing that would be nice, would be a CL command that converted DDS to
SQL.

Nathan.



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