Q

Converting and transferring AS/400 packed decimal fields to ASCII systems

You can send a physical file with packed decimal fields to an ASCII system via iSeries Access or via the CPYTOIMPF command and then send the file with FTP.

I have a physical file in AS/400 that contains data like that: 'BB_¶__LOCLFRAM237'. I want to transfer the file to my PC and convert the packed characters to ASCII. Is there any way to do this?
There are two options:

You can use command CPYTOIMPF. This command convert database file to "flat file" (i.e it makes target file with...

packed represented as strings). The converted file can be sent to ASCII systems using FTP.

You can use file transfer utilities. One example is iSeries Access file transfer, this utility will translate AS/400 fields (including packed decimal fields) to ASCII systems with no problem.

This was last published in November 2008

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close