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
 

 

Conversion of SBCS column to DBCS column

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

New User


Joined: 15 Apr 2006
Posts: 10

PostPosted: Fri Nov 27, 2009 4:00 pm    Post subject: Conversion of SBCS column to DBCS column
Reply with quote

Hi All,

Please help with this problem.

I have a table, say TableA which is residing in a TableSpace assigned with Bufferpool of 4K and CCSID is EBCDIC. TableA has a column "Comment"declared as
Comment VARCHAR(2048) FOR SBCS DATA. This field accepts the text input from the user from the front-end, probably Lotus notes.
When user is trying to enter GERMAN characters in this field, it is resulting in an overflow abend. We now need to provide the solution to avoid overflow abend.

We though of different ways.
1. To increase the field size:
As there is a limitation to the VARCHAR declaration (max 4000 bytes), even though we now increase it to 4000, in future if user enters few more German characters it may again result in an abend. And moreover the table space need to be altered to accommodate more bufferpool size(8k or so).

2. To convert the column from SBCS to DBCS:
Am not able to find anyway how to convert this. If i just try creating a sample table with VARCHAR(2048) FOR DBCS DATA, am getting DB2 error saying that DBCS is not a valid word.

3. Redefining the table with CCSID as UNICODE:
Will the UNICODE support double byte characters more efficiently than EBCDIC?
If so, what would be the impact to the existing data (which is in EBCDIC format) when loaded into the table defined with UNICODE.
How to do the conversion from EBCDIC to UNICODE?

If you think there is any other better solution with minimum impact to the data, please do suggest.

Thanks in advance
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Fri Nov 27, 2009 6:42 pm    Post subject:
Reply with quote

Quote:
Will the UNICODE support double byte characters more efficiently than EBCDIC?


methinks you need to learn a bit more.
Back to top
View user's profile Send private message
Sumeru

New User


Joined: 15 Apr 2006
Posts: 10

PostPosted: Thu Dec 03, 2009 12:15 pm    Post subject:
Reply with quote

I inserted German and Chineese charcaters into two tables.. One defined as EBCDIC and other defined as UNICODE. While trying to view the data, i am seeing ???? in place of the characters. What can be done to view those characters as it is?

Can anyone please suggest me?
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 Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
This topic is locked: you cannot edit posts or make replies. DB2 query Using Recursion, Converting... smilewithashu2 DB2 3 Tue Jan 03, 2017 12:50 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 6 Sun Nov 06, 2016 8:11 pm
No new posts Conversion of a VB file to FB. isssal DFSORT/ICETOOL 1 Mon Oct 31, 2016 10:23 pm


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