I need to store unicode data in db2 tables and retrieve it

friend_prasad · New User Joined: 06 Jan 2006 Posts: 12

Hi all,

I need to store unicode data in db2 tables and retrieve it in unicode format .
Kindly let me know if there are any special considerations for it.
A sample code will be highly appreciated.

logaas · New User Joined: 19 Feb 2005 Posts: 25 Location: chennai

Hi,

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.
For example,
CCSID 37 equates to U.S. EBCDIC,
CCSID 437 equates to U.S. ASCII
CCSID 1208 equates to Unicode

Thanks,
logaas

friend_prasad · New User Joined: 06 Jan 2006 Posts: 12

Hi,

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.