Midrange News for the IBM i Community


Posted by: Deepak Deshpande
AS/400 Freelance Programmer/Analyst
India
CPYF from a PF to flat file (With -ve values)
has no ratings.
Published: 19 Jul 2013
Revised: 19 Jul 2013 - 1801 days ago
Last viewed on: 24 Jun 2018 (3359 views) 

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.

CPYF from a PF to flat file (With -ve values) Published by: Deepak Deshpande on 19 Jul 2013 view comments(4)

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

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS