I am working with a DB2 database on an AS/400 and I would like to insert data from a flat file. The problem is I don't know how to specify how to insert it. I know how to make derived fields using query by using the substring command. Is there a way to use the substring command and substring out part of a flat file record. Thanks in advance for any help.