Re: convert dds to ddl

["Crispin Bates" <cbates@xxxxxxxxxxx>]

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.