When using CreateTable, TBatchmove, or the Datapump tool, EASYCOM creates AS/400 files.
You might want to change the file descriptions.
With EASYCOM, files can be created with DDS or with SQL.
1. When creating table using DDS
DDS is used if the AS/400 file name fit 10 characters and CRTTABLE SCRIPT setting of CONVERSION RULES is not used.
The DDS source is created in QDDSSRC in the library you created the file.
You will have the original field name in COLHDG if it is longer than 10 characters.
You will also have the ALIAS clause to have long names with your DDS.
All fields will be null capable by default.
So you can change the source, and simply recompile it!
2. When creating table using SQL
SQL is used when file names are longer that 10 characters (AS/400 long file names) or when CRTTABLE SCRIPT option in CONVERSION RULES option is used.
You can have the SQL statements generated in a PC file.
Change CONVERSION RULES like this:
CONVERSION RULES=CRTTABLE SCRIPT=
You will have all the SQL table creation statements generated in that file. You will just have to transfer it to your AS/400 and use RUNSQLSTM to execute it after modifications.
This file will also contain the index creation statements.