IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

character setting configuration into DB2 for Z/OS


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sakthikumarT

New User


Joined: 09 Apr 2009
Posts: 50
Location: Bangalore

PostPosted: Thu Nov 05, 2015 11:37 am
Reply with quote

Dear All,

i have been asked this Question.
We are using your z/OS DB2 database for developing and testing one of our product.
We found that this database is special with its character setting to be JAPAN EBCDIC DB. And this setting make us failed to retrieve GRAPHIC AND LOB datatype values with other language(like Chinese) characters.

So, could you help us do some configuration for implicit character conversion. This action requires admin user privilege.

Another thing we know is that this database’s MCCSID is 24876, but I didn’t find its GCCSID or ASCCSID.

Also if you want to test the setting is effective or not, please verify the
result of this query “select * from GRAPHIC_TB;” to be readable.

**************************************************
I have suggested them
1. Create a table with CCSID as UNICODE.
2 . In order to get the data in a readable format do casting for the columns

Now they are able to see the data properly. but they want know the following
1. is there any way to handle the Default Encoding table.
2. adding implicit character conversion .( i have never done this before).

Since most of the senior resources are Voluntary retirements. so i have to handle all the responsibility.

Any suggestions or pointers will be very Helpful.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2508
Location: NY,USA

PostPosted: Thu Nov 05, 2015 9:04 pm
Reply with quote

Haven't below link helped?
Use [URL] BBCode for Links
Back to top
View user's profile Send private message
sakthikumarT

New User


Joined: 09 Apr 2009
Posts: 50
Location: Bangalore

PostPosted: Thu Nov 05, 2015 10:26 pm
Reply with quote

This may be helpful in the Future but ar of now i am looking out for those 2 things
1. How to change the Default encoding Scheme E to U.( what i have understood is during installation of DB2 the Default Encoding Scheme should be decided in our case it is E. )
there should be someway to change this. ( since my tso id is having all the privileges i can give a try )

2. could you help us do some configuration for implicit character conversion.

Warm Regards,
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2508
Location: NY,USA

PostPosted: Thu Nov 05, 2015 10:53 pm
Reply with quote

1.May be you should look for ENCODING_SCHEME col in SYSIBM.SYSDATABASE table to change it.
2.Please check upon,
Use [URL] BBCode for Links
Use [URL] BBCode for Links
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10695
Location: italy

PostPosted: Thu Nov 05, 2015 11:08 pm
Reply with quote

Quote:
Since most of the senior resources are Voluntary retirements. so i have to handle all the responsibility.

thats what happens with workforce realignment icon_cool.gif
Quote:
voluntary
icon_lol.gif icon_lol.gif icon_lol.gif
Back to top
View user's profile Send private message
sakthikumarT

New User


Joined: 09 Apr 2009
Posts: 50
Location: Bangalore

PostPosted: Tue Nov 17, 2015 10:58 am
Reply with quote

Hi All,
I have Found few Information.

The UCS customization process includes the following six steps:

1.Get the original conversion table in text mode.
2.Customize the conversion table in text mode.
3.Generate the binary conversion table.
4.Apply the conversion table to the system.
5.Update the z/OS system for the next IPL.
6.Update the application runtime environment to pick up the new conversion table.

Please let me know your comments.

Warm Regards
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Compare two character variables Head ... CLIST & REXX 3
No new posts DSNTEP2 - setting exception DB2 2
No new posts Foreign character look different in m... COBOL Programming 3
No new posts CICS Web Services configuration question CICS 36
No new posts SARBCH PRINTJOB option not Works with... CA Products 4

Back to Top