Modify Hexadecimal 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
Software/Hardware used:
As/400 , Iseries
ASKED:
November 11, 2012 10:12 PM
UPDATED:
November 12, 2012 2:35 AM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
Ben Rubenstein 
2,060 pts. ,
As400t 10 pts.
2,060 pts. ,
As400t 10 pts. To see all answers submitted to the Answer Wiki: View Answer History.
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
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.