Re: convert dds to ddl

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.