RE: convert dds to ddl

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

For tables?!?!  Sparked my curiosity!  Is this done via after-the-fact
RNMOBJ or something else?  Do tell!

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
?...Yes, the lectures are optional.  Graduation is also optional.?
        -- Professor Brian Quinn 


> 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.



> > 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.