AS/400 Transfer

Data Extaction and Cleansing as/400

What is the best way to extract and clean data from AS/400 dbase?  We are planning to replace legacy systems with an integrated package that may have a different dbase.  Is there a good product / service? Software/Hardware used: as/400

Download from iSeries to PC (TAB delimited text)

Hi, 1.  I would like to download a file from AS/400 to PC as a TAB delimited text.  However, I realised number decimal appears as '20000.' where it should be '20000.00'.  Is there somewhere to define the format during data transfer ? 2.  Can a delimitter be changed to '|' instead of TAB ?  ...

Automatic transfer of AS400 output file to PC folder

Is there a way to automatically transfer an output file to PC folder in an Excel form? My boss want me to create a CL program that every time the output file was created, it automatically convert that output file to Excel(numeric values in comma seperated) in a PC folder. I usually do this...