AS400-DDL
I have created table using CREATE TABLE Command. I want to see the source of Table. Is there possiblity to view the TABLE's Source in AS400
Software/Hardware used:
Software/Hardware used:
ASKED:
September 4, 2008 3:40 AM
UPDATED:
November 17, 2011 11:15 AM
Answer Wiki:
<ul>
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.
<ul>
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
