Re: convert dds to ddl

["Crispin Bates" <cbates@xxxxxxxxxxx>]

As I said in my very first reply. At V5R4 you no longer need to replace the 
PF with an LF because the RCDFMT clause was added to CREATE TABLE...


----- Original Message ----- 
From: "Gqcy" <gmufasa01@xxxxxxxxx>
Newsgroups: midrange.midrange-l
To: <midrange-l@xxxxxxxxxxxx>
Sent: Friday, August 06, 2010 1:12 PM
Subject: Re: convert dds to ddl


> My understanding was that I needed DDS Logicals to get the same format
> level id.
> It appears that with 6.1 that isn't the case, in that DDL (SQL) defined
> files will have the same format id as the DDS physicals and logicals.
>
> I have tested the "GENDDL" tool, and have proven that it will generate
> the SQL that matches the fmt ID of the DDS files.  So this means that I
> don't have to create logical files out of my old physicals.
>
> -gerald
>
>
>
>
>
>
> rob@xxxxxxxxx wrote:
> > Not sure about this:
> > <snip>
> > I will create new SQL indexes prior to re-creating my old logicals.
> > what else can/should I do to my logicals?
> > </snip>
> > Were you thinking about recreating your logicals in DDS, but first create
> > indexes?  I do not see a reason to use DDS to recreate your logicals.
> >
> > Some indexes you may not have but which may come in handy ...
> > 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
> --
> 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.