The data in the DB2 will be coded in some CCSID format.It needs a conversion for proper display when viewed on a different m/c.For example for the data to be visible in English : CHGJOB CCSID(37) command should be run at the command prompt.Based on the language in which you would like to view, appropriate CCSID should be used.
The picture show the data displayed from a table before running the command CHGJOB CCSID(37).
The picture show the data displayed from a table before running the command CHGJOB CCSID(37).
- CCSID stands for Coded Character Set ID.
- A CCSID of 65535 means the data is coded in Hex
Some times you may get "SQL0332 - Characterconversion between CCSID &1 and CCSID &2 not valid".Refer this for more information SQL0332
Use full links related to CCSID here here
No comments:
Post a Comment