Using CVTPFXLS to convert a datafile

995 pts.
Tags:
AS/400
CVTPFXLS
Can anyone help here please. I am using the CVTPFXLS command to convert a datafile to xls but the negative packed fields are not getting translated correctly. The negative signs are dropping out. Cannot see any options on the command. Cheers!

Answer Wiki

Thanks. We'll let you know when a new response is added.

CVTPFXLS is not an IBM command.
It is a shareshare command.
Here is the link that explains it.

http://itknowledgeexchange.techtarget.com/itanswers/as400-to-excel-2/

Discuss This Question: 9  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Teandy
    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?
    5,860 pointsBadges:
    report
  • tjgm88
    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')
    995 pointsBadges:
    report
  • philpl1jb
    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
    50,415 pointsBadges:
    report
  • tjgm88
    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.
    995 pointsBadges:
    report
  • Teandy
    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’)
    
    5,860 pointsBadges:
    report
  • tjgm88
    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.
    995 pointsBadges:
    report
  • Teandy
    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              
    
    5,860 pointsBadges:
    report
  • tjgm88
    The same date - 18/02/03. So we seem to have the same version.
    995 pointsBadges:
    report
  • Teandy
    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.
    5,860 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following