Inserting and viewing of Chinese characters in DB2400

5 pts.
Tags:
AS/400 DB2
CCSID
DB2 administration
IBM DB2
Dear All, We are trying to insert Chinese characters into an AS400 PF. We originally had the CCSID of the PF field as 13488, The job CCSID being 65535 HOWERVER when we are trying to input characters, it is taking as ????????? Later, we careated a new file - with CCSID 1200 and still the same thing is happening. We changed the job ccsid to 935 and still it is doing the same. We are using Reflection client for IBM AS400. Please suggest a solution to do this. Regards, Vijay

Software/Hardware used:
DB2400

Answer Wiki

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

Here is a link with information

http://www.mcpressonline.com/forum/showthread.php?8597-Chinese-Charater-input-display-on-AS400

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.

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
  • TomLiotta
    The job CCSID being 65535... Since 65535 is 'binary' by definition (i.e., no CCSID is applied), don't use it. That's the first step; there may be others. Use DSPJOB to see the 'Job Definition Attributes'. Scroll down to see the 'Coded character set identifier' that would be 65535. Just below that, you should see 'Default coded character set identifier'. Then use the CHGJOB command to change the job's CCSID() attribute to be the value from the job's default CCSID. At that point, actions in that job should begin to work through the new CCSID setting rather than as binary (non-conversion). See how that affects actions with the Chinese characters. Then, what devices are you using to enter and/or view Chinese characters? If those devices are not capable of handling input or output of the characters, you'll need to update (or upgrade) them appropriately. (As a trivial example, an old IBM Selectric typewriter would normally be incapable of typing anything but English characters. But the Selectric ballcould be swapped out to change the character set. Emulator sessions, printers, etc., nowadays have software options that may need to be applied.) Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    Note that CHGJOB CCSID() for the new CCSID would need to be done every time a new job starts. A CCSID can be set for individual users with the CHGUSRPRF command -- that could eliminate needing CHGJOB each time a user who needs character conversions starts a job. And again, this is only one step. Tom
    125,585 pointsBadges:
    report
  • bvining
    I have no familiarlity with Reflection, but I notice that both CCSIDs you;re using are Unicode based (which is certainly the way to go). How are you writing the data to the file? Are you using SQL or file IO from a HLL program? When you say you're getting ??????, what does that mean and where are you seeing it?
    6,495 pointsBadges:
    report
  • TomLiotta
    Welcome to the question, Bruce. I was hoping you'd take this. @Vijay: Pay attention to what Bruce says and asks. Especially on this subject, you're not going to get better advice (at least for free and even for significant cost). Tom
    125,585 pointsBadges:
    report
  • Vkm
    [...] 5. CharlieBrowne and TomLiotta gave their best tips for finding the RPG38 source after the LIBTEST has been deleted. 6. TomLiotta, CharlieBrowne, and Bvining have come together to help a member with inserting and viewing of Chinese characters in DB2/400. [...]
    0 pointsBadges:
    report
  • Vkm
    [...] Inserting and viewing of Chinese characters in DB2/400 [...]
    0 pointsBadges:
    report
  • Mdshadabalam
    Hello Tom, I have also same requirement to upload the chinese report in AS400 data base. I follow your below given step but still it not getting uploading. kindly provide me the compelete step. Regards, Shadab
    85 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