For generating SQL source:</ul>
If you have the iseries navigator, go to <machine> Databases <machine> Schemas <library> Tables. Right click on the required table and select ‘Generate SQL’. Do remember to click checkbox ‘include object short names’, in case the table has column/field names more than 10 chars long.
For DDS source:</ul>
On AS/400, you will need an advanced file editor like Filescope platinum (shwfc), which can generate DDS from a database file.
You can use DSPFFD to see field attributes, short names, etc.