Configure coded character on AS/400

280 pts.
Tags:
AS/400
Client Access
How can configure the Coded Character Set on my AS/400 client access to be (420) in order to receive data in Arabic from AS/400?
0

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.

Discuss This Question: 7  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.
  • chalenger

    Dears,

    on client Pc : open IBMI Access Properites, Language then set Ebcdic CCSID 420

    Regards

    620 pointsBadges:
    report
  • Messam

    HI CHALENGER,

    good day I did try this but I still have the same problem

    thanks

    280 pointsBadges:
    report
  • chalenger

    Dear Messam,

    Kindly clarify what do you mean by "to receive data in Arabic from AS/400? " Do you mean File Transfer? if so the file itself should has 420.. just use  Chgpf

    Regards

    620 pointsBadges:
    report
  • Messam

    dear
    thanks for your kind reply .

    yes this is what I mean . and  I need to receive to receive data in Arabic from AS/400? but I use Query to create this file so I could not use the command
    CHGPF FILE(HSAMIR/R201412) LANGID(420)
    as an error message Parameter not allowed with SRCFILE(*NONE)

    Regards

    280 pointsBadges:
    report
  • bvining
    You would use CHGPF FILE(HSAMIR/R201412) CCSID(420) and NOT LANGID(420).

    BUT I suspect this isn't really what you want either. Changing the PF with the CCSID parameter will change the CCSID associated with the data, but not the data itself. Is the data you are querying already 420? If so then query should have created the output file for you using 420. If it's not already 420, what makes you think there's anything in the file of an Arabic nature to begin with? Is this Unicode data you're querying? If you use DSPFFD FILE(HSAMIR/R201412), right after running the query, what CCSID is query currently using for the character data?

    And just to play it safe, you are aware that CCSID conversion is NOT language translation (as in English to Arabic), it's just code point conversion so that, for instance, a '$' stays a '$' regardless of the data encoding in use by the receiving system.

    Bruce Vining
    7,070 pointsBadges:
    report
  • Messam

    dear bvining,
    in the beginning i would like to thank you for your reply , yes the data you are querying already 420 . and the query output file using 420. so i see the Arabic data only if i display the physical file from as400 side .
    when i use the tool of data transfer from system I to EXCEL sheet in my PC the data in Arabic appearing corrupted.

    thanks

    280 pointsBadges:
    report
  • chalenger

    Have you tried File transfer rather than EXCEL?

    what about Arabic language in MS office? is it OK?

    Regards

    620 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.

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

Following

Share this item with your network: