IBMiAccess




Results 1 to 6 of 6

Thread: Iseries Access File transfer

  1. #1
    Analyst CessnaDriver's Avatar
    Join Date
    Aug 2006
    Location
    Keller, TX
    Age
    44
    Posts
    231
    Rep Power
    923

    Iseries Access File transfer

    I have a transfer request for our Inovis EDI master file that's been working great for a few months.

    Over the weekend, I upgraded TrustedLink Iseries from 6.1.4 to 6.2.0.

    Now when we run our file transfer request, all of the data is in hexadecimal.

    When I look at the field field description of EDMAST on the '400, it says the fields are character.... and I can read them if I do a query on the '400 over the file.

    Only the file transfer seems to be affected.

    Any ideas? I am stumped on this one.

  2. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Age
    21
    Posts
    1,000,000
     

  3. #2
    Analyst CessnaDriver's Avatar
    Join Date
    Aug 2006
    Location
    Keller, TX
    Age
    44
    Posts
    231
    Rep Power
    923

    Re: Iseries Access File transfer

    I don't have the source for the file, but when I do a DSPFFD it shows that the fields are "char".

    When I go into the file transfer and look at the file layout, they show as hex.

    Strange! (at least to me it is)

  4. #3
    VP of Beverage Stimulants jtemple's Avatar
    Join Date
    Feb 2006
    Location
    Missouri
    Age
    47
    Posts
    924
    Rep Power
    2271

    Re: Iseries Access File transfer

    Did the CCSID of the fields change? Reason is, I've seen CCSID 65535 look strange when un-translated.

  5. #4
    Analyst CessnaDriver's Avatar
    Join Date
    Aug 2006
    Location
    Keller, TX
    Age
    44
    Posts
    231
    Rep Power
    923

    Re: Iseries Access File transfer

    Quote Originally Posted by jtemple View Post
    Did the CCSID of the fields change? Reason is, I've seen CCSID 65535 look strange when un-translated.

    *DING*

    That was it. I figured it out about 30 minutes ago and was just signing in to update everyone.

    If you go under file, and then properties, there is a check box "convert CCSID 65535". I checked it and then it started working.

    They did change the CCSID from 37 to 65535 for some reason. I found it in their release notes.

  6. #5
    VP of Beverage Stimulants jtemple's Avatar
    Join Date
    Feb 2006
    Location
    Missouri
    Age
    47
    Posts
    924
    Rep Power
    2271

    Re: Iseries Access File transfer

    I "think" and I can't confirm that some software companies (JDE being one of them) use this CCSID to help in internationalizing their application. I believe it stems from supporting DBCS systems...not sure of that, though.

  7. #6
    Programmer/Analyst I bryce4president's Avatar
    Join Date
    Apr 2007
    Location
    Lewisburg, PA
    Age
    31
    Posts
    2,895
    Rep Power
    4663

    Re: Iseries Access File transfer

    Excel does the same thing. You have to convert the CCSID when you upload or you get garbage data.
    Your future President
    Bryce

    ---------------------------------------------
    http://www.bravobryce.com

  8. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Age
    21
    Posts
    1,000,000
     

Facebook Comments


Similar Threads

  1. iSeries Access MS Windows Commands Copy/Cut and Paste
    By jamief in forum Tips for the Iseries/AS400
    Replies: 10
    Last Post: October 15th, 2007, 05:53 AM
  2. Regd moving
    By sudha in forum Iseries System administration
    Replies: 4
    Last Post: April 26th, 2007, 09:17 AM
  3. automated download of PF to Excel file with Client Access
    By itp in forum Tips for the Iseries/AS400
    Replies: 11
    Last Post: December 21st, 2006, 04:49 PM
  4. Transferring Save file
    By vivek in forum RPG/RPGLE
    Replies: 13
    Last Post: July 10th, 2006, 10:32 PM
  5. Cpytoimpf
    By joan400 in forum DDS
    Replies: 5
    Last Post: October 26th, 2004, 10:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •