Re: Looking for file structure details

If you happen to have DBU from ProData installed on your system you might
try DBU'ing the table/file and then F4=List fields>F9=Export fields>1.
Export DDS. It works pretty well for files originally created with DDS
and not so well for tables created with SQL DDL.

On Thu, Jun 25, 2015 at 1:57 PM, John R. Smith, Jr. <
smith5646midrange@xxxxxxxxx> wrote:

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?

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