Re: Looking for file structure details

[Mike Garrison <ibmisoftwareengineer@xxxxxxxxx>]

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.