Need to Convert ASCII Files into AS/400

[Magnus01]

I need to convert a ASCII File into AS/400. More specifically I need to convert a AIMS (A foxpro program) database into AS/400. Any information on how I would go about doing this Would be extreamly helpful. I don't need a program that will do this because I myself am in the process of writing a program which will need to do this.
Thank you in advance for your sharing of knowledge.

 

[SpeedOLight]

Do you have any tools? Client Access ODBC? Can you FTP it?

If using Client Acess, can create an ODBC connection and just do inserts of the Foxpro records.

If using FTP, will need to export foxpro table(s) into a text file, and then FTP the file.

Both ODBC and FTP will resolve the code page translation from ASCII to EBCDIC.

Regards...Marc
Independent Software Consultant

 

[cspilman]

Got dd?

the dd command has the conv function that allows you to convert to different file types (i.e. from ASCII to EBCDIC, and vice versa). Take a look at the man pages for the proper syntax.

Have Fun!
Chuck

 

[Krash878]

Recently I took and excell spread sheet and imported it into Access. I used Access's export function to export and define the record lengths and fields. Then I used Client Access to transfer the file to the AS400. Worked well and now is very quick.

Hope this helps

Krash

 

[leveyp]

Take a look at the OS/400 CPYFRMSTMF (Copy From Steam File)
command