Teandy   4495 pts.  |   Dec 1 2009  8:08PM GMT

I use this command a lot and have never seen this behavior. How are the fields defined in the file? Can you post a sample of the DDS?

Tjgm88   510 pts.  |   Dec 1 2009  8:57PM GMT

Here is the DDS for the file (only the numeric fields are the issue. The negative sign is not being carried thru:
:
A WP1$ 13S 2
A TEXT(’WP Year -2′)
A NB1$ 13S 2
A TEXT(’NB Year -2′)
A WP2$ 13S 2
A TEXT(’WP Year -1′)
A NB2$ 13S 2
A TEXT(’NB Year -1′)
A WP3$ 13S 2
A TEXT(’WP Year 0′)
A NB3$ 13S 2
A TEXT(’NB Year 0′)
A WPP$ 5S 2
A TEXT(’WP % Change’)
A NBP$ 5S 2
A TEXT(’NB % Change’)

Philpl1jb   25660 pts.  |   Dec 2 2009  2:08AM GMT

This is apparently a non-IBM freebee
There was a PTF issued for this issue - you want to find it or a latter version of the software. Google AS/400 CVTPFXLS negative
Phil

Tjgm88   510 pts.  |   Dec 2 2009  4:43AM GMT

I have not been able to find the PTF nor a later version of the command. Seems its no longer on the web. Its a fairly straight foward file and can’t see why it cannot handle negatives.
Anyway, I have resolved the problem by converting the numerics to alpha and adding the negative sign myself.
Thanks guys.

Teandy   4495 pts.  |   Dec 2 2009  8:17PM GMT

I do not define my fields as signed numberic when I create a file. I define everything as packed.

Just for fun, try defining the field as follows and see if that makes a difference.

A WP1$ 13  2   TEXT(’WP Year -2′)
A NB1$ 13   2  TEXT(’NB Year -2′)
A WP2$ 13  2  TEXT(’WP Year -1′)
A NB2$ 13  2   TEXT(’NB Year -1′)
A WP3$ 13  2  TEXT(’WP Year 0′)
A NB3$ 13  2   TEXT(’NB Year 0′)
A WPP$  5  2   TEXT(’WP % Change’)
A NBP$  5  2  TEXT(’NB % Change’)

Tjgm88   510 pts.  |   Dec 2 2009  9:45PM GMT

Hi Teandy,

Thanks for your tips. I had the fields as packed intially. When it didn’t work, changed them to zoned which also did not work. Some are saying that it is a known bug and there is a PTF to fix it. But I am not able to find the website from where I got the original. Wonder if anyone can direct me to download the later version of the command.
Thanks.

Teandy   4495 pts.  |   Dec 3 2009  2:21PM GMT

What is the creation date of your CVTPFXLS command? Mine is as follows:

Creation date/time . . . . . . . . . :   02/18/03  11:14:04
Created by user  . . . . . . . . . . :   NUBLA_A
System created on  . . . . . . . . . :   PSI#E
Object domain  . . . . . . . . . . . :   *SYSTEM

Tjgm88   510 pts.  |   Dec 4 2009  5:51AM GMT

The same date - 18/02/03. So we seem to have the same version.

Teandy   4495 pts.  |   Dec 4 2009  10:13PM GMT

I use this command all the time and have never seen what you describe.

At this point the only thing I can think of would be to restore the original save file and see if that fixes your problem.