Looking for file structure details

I need to generate DDS for a BUNCH of PFs. I have tried several versions of
programs that retrieve DDS and all of them seem to have bugs that are making
this task even more difficult. To add more difficulty, some of the specific
in them (record format name, keys, etc.) has to be modified slightly from
the original.



I have given up on the freebie products and I am working on writing
something that will do exactly what I need. To do this, I am trying to
avoid APIs and DSPFFDs to an outfile. Instead I am trying to obtain the
details using sql. I found SYSCOLUMNS which provides all of the field level
information. I have not been able to find anything that tells me the record
formats or keys. Also, if the file has multiple record formats, how do I
know which fields in SYSCOLUMNS belongs to which format?



We are running 6.1.



Can anyone help point me in the right direction?