Re: Transfer numeric data to ASCII

Data can be extracted into an ASCII format using the Client Access Data
Transfer From iSeries utility.   

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Dawer Khan
Sent: Tuesday, March 28, 2006 9:34 AM
To: SYSTEM21@xxxxxxxxxxxx
Subject: [SYSTEM21] Transfer numeric data to ASCII

I know it has been discussed many times, but I still can not find specific 
scenario I am stuck with. I need to transfer some data base files to PC in 
ASCII format. I have only character and signed numeric values in these 
files, no packed fields. When I try to use CPYTOIMPF command to transfer 
these files into flat files, I am getting problem in numeric fields. For 
every numeric field it drags the position of next value by two digits 
because of placing sign (-ve) and decimal point. 
Is there any way to convert these values without decimal point, say for 
12.50 just convert to 1250. I also tried to use CPYF file to copy the data 
in one text field file, so I can eliminate decimal point it works great 
but then I got problem if there is any -ve value exist. The value looks 
like "125}". Any idea ? 
Thanks Dawer 

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.