Re: convert dds to ddl

I personally would not use the Wiki's strategy. If you are at 6.1 (in fact it was possible at 5.4 as well because the CREATE TABLE had RCDFMT added), then there is no need to replace the existing PF with an LF. Just replace the DDS definition with DDL.

The QSQGNDDL API will generate DDL from the PF. Search for GENDDL or GENSQLDDL to get hold of code that already uses the API. Here's a link to an article about GENSQLDDL - http://systeminetwork.com/article/apis-example-reverse-engineering-database-files-and-objects-sql-ddl-statements

If you have Date fields in your DDS then make sure you load PTF SI40264, otherwise you will get level checks. Other than that, you can replace all of your PF's with DDL without getting any level checks (as far as I have found anyway).

Crispin.


----- Original Message ----- From: "Gqcy" <gmufasa01@xxxxxxxxx>
Newsgroups: midrange.midrange-l
To: <midrange-l@xxxxxxxxxxxx>
Sent: Friday, August 06, 2010 11:02 AM
Subject: 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


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