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.

Shahar Mor, BARMOR

Published: 18 Nov 2008

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...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

Dig Deeper on iSeries Access (Client Access)

Microsoft backtracks, resumes security emails beginning July 3 That suspension didn't last long. Microsoft is going to continue sending security updates via email after reviewing its processes. Late last week, the company said it would stop sending emails to ...

How to configure Database Mail in SQL Server 2005 to send mail Sending mail via SQL Server has become a much more reliable process. Here, SQL Server expert Roman Rehak explains how to configure Profiles and Accounts within the Database Mail architecture for sending and monitoring email.

Microsoft releases Windows Vista Service Pack 1 to Windows Update Microsoft has released Windows Vista Service Pack 1 via its Windows Update service, but will not start automatically sending it to users until "mid-April".

Part 2: How to perform a Telnet SMTP session for Exchange Server 2003 Get a demonstration of how to perform an SMTP session via Telnet to send email messages in Exchange Server 2003.

OutDisk: A simple solution to sending large email attachments Learn about a third-party tool called OutDisk that solves the problem of sending large email attachments via Microsoft Outlook and Exchange Server.

How to send SAPscript via e-mail Learn now to send SAPscript to a customer via e-mail.

Have a question for an expert?

Please add a title for your question

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

Meet all of our AS/400 experts

View all AS/400 questions and answers

Please create a username to comment.

Refresh your data center cooling lexicon

Comparing Linux distributions: Red Hat vs. Ubuntu

Get eco-friendly with LEED data center certification

Dig Deeper on iSeries Access (Client Access)

Related Q&A from Shahar Mor

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.