This tip comes from Don Beeler – This SQL will create two sql scripts: one to create a table and one to insert data into an Oracle table from an AS400 flat file. This process uses a temporary table so that CHARs can be changed to VARCHAR2s. In the INSERT for AS400 CHAR columns, I do RTRIM and LTRIM.
Read More - Register for Free Membership