Inserting and viewing of Chinese characters in DB2400
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
Software/Hardware used:
DB2400
ASKED:
May 3, 2011 5:35 PM
UPDATED:
May 5, 2011 12:37 AM
Answer Wiki:
Here is a link with information
http://www.mcpressonline.com/forum/showthread.php?8597-Chinese-Charater-input-display-on-AS400
To see all answers submitted to the Answer Wiki: View Answer History.
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
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
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?
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