Append extra zero on the numeric field using Data Transfer Excel Add-in

30 pts.
Tags:
DTF
IBM iSeries
iSeries Data Transfer
Microsoft Excel
My PC configration is MS Window 7 Professional (64-bit Traditional Chinese version), MS Office 2010 (32-bit Traditional Chinese version) and IBM Client Access V6R1M0 (64-bit English version).

The problem is that the actual numeric value is 1,2 or 3 only in the physical file. After using the Data Transfer Excel Add-in function to download that physical file via a dtf file, the numeric value is changed as 10, 20 or 30 in the Excel.

However, this problem is occurred randomly, i.e., sometimes happen incorrect value, sometimes is normal. Any idea? Many thanks!



Software/Hardware used:
My PC configration is MS Window 7 Professional (64-bit Traditional Chinese version), MS Office 2010 (32-bit Traditional Chinese version) and IBM Client Access V6R1M0 (64-bit English version).

Answer Wiki

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

Discuss This Question: 6  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
  • Splat
    Is this being run with an existing .dtf? If so, can you open the .dtf and see if the field is being multiplied in the Select= statement?
    7,635 pointsBadges:
    report
  • philpl1jb
    Please tell us the field type and size of the field on the AS/400 Phil
    51,355 pointsBadges:
    report
  • Mingwong
    Thanks for reply, the field type is pack numeric field with length 9v0 the AS/400. I tried two different .dtf to retrieve the AS/400 physical file. One .dtf is set as "decimal(o1qtdl,9,0) as QTY" in the Select statement. Another one .dtf is not set anything and get the field directly. However, both results are same in the Excel, i.e., an extra zero is appended on that numeric field in the Excel, very strange....
    30 pointsBadges:
    report
  • TomLiotta
    this problem is occurred randomly, i.e., sometimes happen incorrect value, sometimes is normal. What is "randomly"? Does it happen on some days but not others? Does it happen on some PCs but not others? Does it happen for some users but not others? Does it happen for some records but not others? Are these from permanent or temporary files on the server? Tom
    125,585 pointsBadges:
    report
  • Mingwong
    "Randomly" means that using same .dtf to download same phsical file via the Data Transfer Excel Add-in function in my computer, the result is normal sometimes, but sometimes, extra zero is appended on the numeric field of some records, not all records. And not only me, other users also face such problem and their Client Access version is V6R1M0, but using MS Excel 2003, i.e., different from my Excel version which is 2010. And the users told me that when her computer configuration was MS Window XP and the Client Access was V5R4 a few months ago, such problem was never happened. That's why I think it is not problem related to the MS Excel and should be the problem of Client Access. Many thanks!
    30 pointsBadges:
    report
  • Splat
    Pardon me if this seems obvious, but are your PTFs for Client Access and OS/400 up to date?
    7,635 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