Search found 7 matches
- 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: 12964
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 ...
- 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: 12964
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?
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?
- 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: 12964
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.
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.
- 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: 12964
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...
- 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: 12964
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...
- Wed Dec 21, 2022 2:07 pm
- Forum: RPG IV
- Topic: Data issue while transferring data From Mainframe to IBM i
- Replies: 0
- Views: 22950
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...
- 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: 12964
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...