Re: convert dds to ddl

["Crispin Bates" <cbates@xxxxxxxxxxx>]

One really annoying thing about QSQGNDDL is that when run against a DDS LF 
with Select/Omit, it casually (oh I could have used so many better 
descriptions for it's behavior there) ignores the Select/Omit and doesn't 
bother to add the WHERE clause. I have a DCREQ open for that one (after 
having a PMR open for it). If they had brought the API up to the DDL 
implementation level with 6.1 it would make replacing LF's that much 
easier...


----- Original Message ----- 
From: <rob@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, August 06, 2010 12:49 PM
Subject: Re: convert dds to ddl
> If you have select/omit logicals (which you can do just fine in DDS on
> 6.1) like this
> CREATE INDEX ROB/gqcyl1
> ON ROB/GQCY
> (MUVALUE)
> WHERE RECID='A'
>
> Then you may also want an index like this first
> CREATE INDEX ROB/gqcyl2
> ON ROB/GQCY
> (recid, MUVALUE)
>
> I think this will help performance of queries over the base table which do
> something like
> SELECT ...
> FROM GQCY
> WHERE RECID='A'...
> And I think you want those created first.
>
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   Gqcy <gmufasa01@xxxxxxxxx>
> To:     midrange-l@xxxxxxxxxxxx
> Date:   08/06/2010 11:04 AM
> Subject:        convert dds to ddl
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
>
> 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.
>
>
> --
> 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.