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 Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 0 Mon Jan 02, 2017 11:16 am
No new posts JES2 JEC: Use UNIX Pipes to Pass Data... Virendra Shambharkar JCL & VSAM 21 Tue Dec 20, 2016 6:55 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am


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