Search found 7 matches

by jaii400
Sun Dec 25, 2022 2:04 pm
Forum: Other ScottKlement.com Tools
Topic: Data issue while transferring data From Mainframe to IBM i
Replies: 8
Views: 6849

Re: Data issue while transferring data From Mainframe to IBM i

Jon, Thanks a lot for you time and support. The DDL provided by the customer was having wrong information. We created PF based on that DDL. So, the data uploaded was not proper. I compared the data in hexadecimal to the DDL and found this discrepancy. It was highlighted to the customer. I created a ...
by jaii400
Sat Dec 24, 2022 10:37 am
Forum: Other ScottKlement.com Tools
Topic: Data issue while transferring data From Mainframe to IBM i
Replies: 8
Views: 6849

Re: Data issue while transferring data From Mainframe to IBM i

Latest Update:

I tried to convert the flat file data (which is moved into IBM i using CPYFRMSTMF) into hexadecimal.

In the hexadecimal format I can see the packed data.

How to convert this hexadecimal data and move into a field which is defined as packed decimal?
by jaii400
Sat Dec 24, 2022 8:23 am
Forum: Other ScottKlement.com Tools
Topic: Data issue while transferring data From Mainframe to IBM i
Replies: 8
Views: 6849

Re: Data issue while transferring data From Mainframe to IBM i

Adding to this I tried to use CPYFRMIMPF.

I'm getting the following error.
2 - The field A in the Field Definition File is not a field in the TOFILE.

Please be noted: I created a Physical file in the data format (DDL) provided in the excel sheet.
by jaii400
Sat Dec 24, 2022 8:20 am
Forum: Other ScottKlement.com Tools
Topic: Data issue while transferring data From Mainframe to IBM i
Replies: 8
Views: 6849

Re: Data issue while transferring data From Mainframe to IBM i

Thanks for the response Jon, It's a onetime activity to store some sensitive history data. I received a excel sheet with field definitions from cobol side. The data provided by them is in a stream format without any field separators. The data provided by them is not CSV it is a single big blob of ch...
by jaii400
Fri Dec 23, 2022 12:33 pm
Forum: Other ScottKlement.com Tools
Topic: Data issue while transferring data From Mainframe to IBM i
Replies: 8
Views: 6849

Re: Data issue while transferring data From Mainframe to IBM i

What does the defintion of the file look like? Both on the mainframe side and on the IBM i? I'm having a flat PF. I'm not aware of the file typein mainframe What does the data in the IFS file look like? Except packed decimal, character data looks fine. And what does your CPY... command look like? Th...
by jaii400
Wed Dec 21, 2022 2:07 pm
Forum: RPG IV
Topic: Data issue while transferring data From Mainframe to IBM i
Replies: 0
Views: 9747

Data issue while transferring data From Mainframe to IBM i

Posted the below topic under "Software Tools" Excuse me for double posting the same topic. Hi, I have received a file from mainframe and I have to store the data in IBM i Physical File. What I tried: Step 1. Moved the mainframe file into IFS folder (changed the CCSID into 838) Step 2: Move...
by jaii400
Wed Dec 21, 2022 2:02 pm
Forum: Other ScottKlement.com Tools
Topic: Data issue while transferring data From Mainframe to IBM i
Replies: 8
Views: 6849

Data issue while transferring data From Mainframe to IBM i

Hi, I have received a file from mainframe and I have to store the data in IBM i Physical File. What I tried: Step 1. Moved the mainframe file into IFS folder (changed the CCSID into 838) Step 2: Move the data from IFS folder to a IBM i Physical file using CPYFRMSTMPF (From CCSID is 838 & To CCSI...