Re: convert dds to ddl

[rob@xxxxxxxxx]

Mark,

A CREATE TABLE can create a file with a key.  Try this:
CREATE TABLE rob/MARK 
(MYKEY CHAR (5 ) NOT NULL, 
 MYDATA CHAR (30) NOT NULL,
 PRIMARY KEY (MYKEY)) 

DSPFD ROB/MARK
...
  Access path . . . . . . . . . . . . . . . . :            Keyed 
  Access path size  . . . . . . . . . . . . . : ACCPTHSIZ  *MAX1TB
  Access path logical page size . . . . . . . : PAGESIZE   *KEYLEN
  Maximum key length  . . . . . . . . . . . . :                5 
...
Access Path Description 
  Access path maintenance . . . . . . . . . . : MAINT      *IMMED 
  Unique key values required  . . . . . . . . : UNIQUE     Yes 
  Access path journaled . . . . . . . . . . . :            No 
  Access path . . . . . . . . . . . . . . . . :            Keyed 
  Constraint Type . . . . . . . . . . . . . . :            PRIMARY 
  Number of key fields  . . . . . . . . . . . :              1 
  Record format . . . . . . . . . . . . . . . :            MARK 
    Key field . . . . . . . . . . . . . . . . :            MYKEY 
      Sequence  . . . . . . . . . . . . . . . :            Ascending
      Sign specified  . . . . . . . . . . . . :            UNSIGNED 
      Zone/digit specified  . . . . . . . . . :            *NONE 
      Alternative collating sequence  . . . . :            No 
...

Rob Berendt