There is a option CCSID available while creating the TABLESPACE.
It Specifies the encoding scheme for tables stored in the table space.
Normally it is given as 37 in mainframes for EBCDIC.
Tryout giving 1208 as CCSID for UNICODE.
CCSID stands for Coded Character Set Identifier, a unique value that identifies a code page.
CCSID 37 equates to U.S. EBCDIC,
CCSID 437 equates to U.S. ASCII
CCSID 1208 equates to Unicode
I have got the idea but can u pls tell me suppose i am storing the data in db2 tables in unicode format then how can i retrive it so that how can we read the data on basis of suppose custmor_key then how can i give the key in unicode i can give it in only ebcdic pls explain.
Can you Pls provide me a sample db2+cobol+sql prog for inserting and retriving the data in db2 tables in unicode format.