RE: cpyfrmimpf

["McGovern, Sean" <Sean.McGovern@xxxxxxxxxxxx>]

0012345 should become 12345.00 shouldn't it ? 00123.45 should become
123.45 ?



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jimmy Green
Sent: 10 June 2009 13:38
To: 'Midrange Systems Technical Discussion'
Subject: RE: cpyfrmimpf

IF the data in the input file  is 0012345  after the cpyfrmimpf it
should be
00123.45 but, it's not.
It's changing to 1234500

The cpyfrmimpf is actually moving the first two bytes to the end for the
decimal.  Is that the way the cpyfrmimpf is supposed to work?????



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Simon Coulter
Sent: Tuesday, June 09, 2009 6:31 PM
To: Midrange Systems Technical Discussion
Subject: Re: cpyfrmimpf


On 10/06/2009, at 5:57 AM, Jimmy Green wrote:

> Example of DDS field in the "to file"
>
> FIELD        00007S02       ALIAS(TST_FIELD)
>
>
>
> The Field Definition file is as follows
>
> -Fldnme beg end nul
>
> FIELD          1      7      0
>
>
>
> The "from file" (.txt) has the data as 0012345
>
> After the CPYFRMIMPF the "to file" has  1234500

What did you expect to see?

1234500 is the correct value for your data applied to the defined  
field. DDS (and therefore the file itself) shows the field as a  
ZONED(7,2) which means the field can hold 7 digits, 5 to the left of  
the implied decimal point and 2 to the right. Therefore the value in  
the field is interpreted as 12345.00 which is correct.


Regards,
Simon Coulter.
--------------------------------------------------------------------
    FlyByNight Software         OS/400, i5/OS Technical Specialists

    http://www.flybynight.com.au/
    Phone: +61 2 6657 8251   Mobile: +61 0411 091 400        /"\
    Fax:   +61 2 6657 8251                                   \ /
                                                              X
                  ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------