Re: convert dds to ddl

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Point of fact...you've _always_ been able to get a DDL created table
to have a record format ID of a DDS created physical.

With the addition of the RCDFMT clause in v5r4, it became easier.  But
it could be done before.

Charles

On Fri, Aug 6, 2010 at 1:12 PM, Gqcy <gmufasa01@xxxxxxxxx> wrote:
> 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.