Creating dds source from SQL Tables

Rob,
 
Your comment:
 
"Or querying the file SYSCOLUMNS in QSYS2."
 
is RIGHT ON.  As additional advice to person writing the question and
others on the i5, anyone using DB2, ORACLE or any industry standard
RDBMS should learn how to find out info on tables, columns, indexes,
etc., by accessing the "system" tables.   In this case as you said,
QSYS2.SYSCOLUMNS, in the real DB2s it's SYSIBM.SYSCOLUMNS, in ORACLE I
believe it is dba_tab_columns or user_tab_columns.   
 
In industry standard RDBMs, there is no such thing as DDS as you only
can use ONE language to create and access your RDBMS; SQL.   If you
learn the standards of industry standard SQL and the common functions of
industry standard RDBMs, you'll be much better off.  This if you have to
work on an industry standard RDBMS either because you have one of those
at your shop or you are forced to learn one because your i5 was replace
by an industry standard RDBMS. 
 
Take care,
 
Dave Odom
Arizona