Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
friend_prasad

New User


Joined: 06 Jan 2006
Posts: 12

PostPosted: Wed Apr 26, 2006 12:34 pm    Post subject: I need to store unicode data in db2 tables and retrieve it
Reply with quote

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.
Back to top
View user's profile Send private message

logaas

New User


Joined: 19 Feb 2005
Posts: 25
Location: chennai

PostPosted: Wed Apr 26, 2006 6:48 pm    Post subject: Re: I need to store unicode data in db2 tables and retrieve
Reply with quote

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
Back to top
View user's profile Send private message
friend_prasad

New User


Joined: 06 Jan 2006
Posts: 12

PostPosted: Thu Apr 27, 2006 12:17 pm    Post subject: Re: I need to store unicode data in db2 tables and retrieve
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us