Birgitta,
That may be the case, but it will only generate a VIEW for a DDS LF, which
pretty much makes it unusable for DDS LF's because they are generally
keyed...
Crispin.
----- Original Message -----
From: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, August 06, 2010 1:08 PM
Subject: AW: convert dds to ddl
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
midrange.com
