RE: MIDRANGE-L Digest, Vol 3, Issue 1073

["John Taylor" <lists@xxxxxxxxxxxxxxxxxxxx>]

Joel,

> As for visibilty, the only thing you don't have is the DDS 
> Source member, but if you take the approach I just outlined 
> you haven't lost anything.  DSPFFD is still available to you: 
> in fact I have a library of procedures and programs that I've 
> written that analyze existing files using DSPFFD and creates 
> the .sql files in the IFS.  That way, if I want to convert 
> from DDS to SQL file generation I don't even have to re-type 
> it.  It's similar in concept to the "dump" features available 
> in other databases.


iSeries Navigator will do this for you "out of the box". Right-click on one
or more files, then select "Generate SQL". Instant DDL script. You can do
this for schemas (libs), tables, types, views, procedures, functions,
aliases, and indexes. When run against a table, it also generates the DDL
code for any associated constraints and triggers.


Regards,

John Taylor