Modify Hexadecimal Flat File in AS/400

10 pts.
Tags:
AS/400
Flat file in AS/400
Hi, I am working on a project, but have got stuck and I need expert advice. I received a flat file from another system (probably a Windows system) in AS/400. The flat file contains the data separated with hexadecimal (x'05') . The file I am receiving is through connect direct. My requirement is to modify the data either through the program or to manually make the data ready to process. Please let me know how I can modify the flat file data in AS/400 so that the file is processed. Appreciate your response.  Thanks & Regards Ashwani

Software/Hardware used:
As/400 , Iseries
ASKED: November 11, 2012  10:12 PM
UPDATED: November 12, 2012  2:35 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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
  • TomLiotta
    First, please define "flat file" in your situation. There are at least two different possibilities: a streamfile or a single-field PF. Next, please define a "Hexadecimal FLat file". What makes it "hexadecimal? What is the file CCSID? How was the file transferred? And what is a "connect direct"? A number of responses are possible to your question. A hex-05 character is just an EBCDIC TAB character. -- Tom
    125,585 pointsBadges:
    report
  • NeilD
    Presumably you are receiving a streamfile via FTP (?). The file is Tab delimited (Hex x'05') and you need to strip out the data into a meaningful form.First task after the FTP is to get the file into a DB2 PF via CPYFRMSTMF or an alternative tool.Next you need to scan the PF for the tab delimitter which identifies the beginning/end of each field and write those fields to a workfile of some description thus giving you meaningful data.Hope this helps to get your design process rolling.Neil.
    420 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.

Following