asked on

Converting AS400 file with packed Decimal fields to ASCII

Team,

I am in need for a suitable tool which can do the converstion from AS400 EBCDIC to Windows ASCII and vis versa from command prompt. I don't have CA and I can't buy expensive tools.

If there is a way to have a direct socket connection (either through ODBC or JDBC) that will be ok but I need the suitable driver and I don't want to buy Microsoft HIS for example.

Appreciate your quick response.

Thanks in advanced

dedy_djajapermana

hi,

use windows FTP that:
1. do remote execute CPTOIMPF; CPYTOIMPF will convert packed decimal to normal decimal. You can test the command first.
2. GET the result of the CPYTOIMPF

Please let me know if you need example.

Jablif

ASKER

Hi Dedy,

Thanks for your reply.

Actually, I appreciate if you give the example so I better execute it.

Thanks again

ASKER CERTIFIED SOLUTION

dedy_djajapermana

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dedy_djajapermana

hi dave,

note that i put cpytoimpf, and ftp the CPYTOIMPF'ed file, not the file with packed field.

dd

Jablif

ASKER

Thanks a lot Dedy I will try that then will let you know the result.

Hi Dave,

I have read the mentioned thread but it was talking about either using CA or MS HIS. I don't have them both.

daveslater

Hi dedy_djajapermana

sorry, I did not see that bit. It iis best to go with dedy_djajapermana solition and ignore my comment as it will over complicate things

dave