AW: convert dds to ddl

["Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>]

iSeries Navigator database allows you to easily generate an SQL script (that
can be executed for example by RUNSQLSTM) for any database object you want.
Database --> Schema (select the schema you want) --> Select the database
objects you  want --> right click and generate SQL.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Gqcy
Gesendet: Friday, 06. August 2010 17:03
An: midrange-l@xxxxxxxxxxxx
Betreff: convert dds to ddl


I have been doing some reading, and I am ready to create a procedure for 
us to convert our database from dds to ddl.  (making sure level id's are 
protected)
> http://wiki.midrange.com/index.php/Sql_convert_from_dds



some questions:

we are at 6.1.  is there a benefit to wait for 7.1?


I know I can add field alias, change column text, and field text.
what else can/should I put in the SQL, without changing the level id?

I will create new SQL indexes prior to re-creating my old logicals.
what else can/should I do to my logicals?


Thanks so much.

gerald