CPYF from a PF to flat file (With -ve values)

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 - 3103 days ago
Last viewed on: 14 Jan 2022 (4655 views)

Main URL:

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

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

Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)

Posted by: bobcozzi

Site Admin ****

Chicagoland

www.cozTools.com/qryfile

Comment on: CPYF from a PF to flat file (With -ve values)
Posted: 8 years 6 months 14 hours 13 minutes ago

What do you want to do instead? Swallow the negative value? Insert a - before/after the number?

There's no built-in method to do that in CPYF, but there are tools and programming techniques. So you're going to have to write something.

Posted by: clbirk

Premium member *

Comment on: CPYF from a PF to flat file (With -ve values)
Posted: 8 years 6 months 13 hours 56 minutes ago

The only way I would know short of writing something would be that you copy to an import file (like a csv or tab) in the ifs and with the field definitions it would put out -14.55 for you but obviously the file format would be different than it is now.

Posted by: DeepakD

Premium member *

India

Comment on: CPYF from a PF to flat file (With -ve values)
Posted: 8 years 6 months 13 hours 46 minutes ago

Bob,

Yes, I want to retain the -ve sign in the flat file. And I guessed there is no direct way using CPYF.

clbirk,

Yes, with the limitation of Input & Output file format, best way to achieve this is to write a small RPG and that's what I did.

Thanks to both of you for your reponses.

Deepak

Posted by: DaleB

Premium member *

Reading, PA

Comment on: CPYF from a PF to flat file (With -ve values)
Posted: 8 years 6 months 9 hours 38 minutes ago

How does CPYTOIMPF handle negative numbers? CPYTOIMPF does allow a flat file for TOFILE().