RE: convert dds to ddl

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

One can specify (at least) primary key on a table, thereby making the index
with one step.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
I bought my brother some gift-wrap for Christmas.  I took it to the Gift
Wrap department and told them to wrap it, but in a different print so he
would know when to stop unwrapping. 


> AFAIK, CREATE TABLE creates a physical file with only "arrival
> sequence"
> (access path), so if you have a physical file that has keys, you cannot
> create a direct equivalent with only a TABLE ...
>
> You would have to create an SQL INDEX also, and so then, what would you
> propose to do? Perhaps create the TABLE with a (slightly) different
> name, and then create an SQL INDEX with the same name as the original
> "keyed" physical file?
>
> Would not that be the same as the previously suggested approach of
> creating a Logical File with the same name as the original file, and
> that has the necessary keys also defined? Then, CRTLF will create the
> logical file which will also have the correct (possibly shared) access
> path associated with it.