Re: Looking for file structure details

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

John

There's an API to generate the CREATE statements - it is used in 
Navigator, so the easy route is to go to Navigator under the Database 
items, show the table in a schema, right-click and generate SQL...

Now that's a one-at-a-time thing, probably. So the API is the way to go, 
IMO.

Here's an article that gives you lots to work with - it includes a 
command you could use in PDM or as a user action in RSE.

http://www.ibmsystemsmag.com/ibmi/developer/general/Generating-DDL-Source-Using-a-CL-Command/

My google was over "generate ddl ibm i api" - the actual API name is 
QSQGNDDL and should help get a better hit list.

HTH
Vern


On 6/25/2015 1:57 PM, John R. Smith, Jr. 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?