Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
Hi
We have one CL where a PF is copied to a flat file to be FTPed later.
The PF has some amounts which can be negative. After CPYF to flat file, last digit from these negative values gets replaced by a char as follows:
o --> }
1 to 9 --> J through R
Example: 51.88- becomes 518Q and 130.30- becoems 1303}
Is there any way to avoid this? I know, I can write one small RPG program & do this. Just wondering if I can avoid that.
TIA
Deepak