IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 double byte data in a non DBCS table


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

New User


Joined: 08 Oct 2007
Posts: 13
Location: India

PostPosted: Thu Jul 24, 2008 11:55 am
Reply with quote

We need to insert some Japan characters(double byte) into a table which is not DBCS supported. Can anyone please help me in this.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jul 24, 2008 1:08 pm
Reply with quote

Hello,

Bite the bullet and change the table.
Back to top
View user's profile Send private message
sailaja cherla

New User


Joined: 08 Oct 2007
Posts: 13
Location: India

PostPosted: Thu Jul 24, 2008 2:40 pm
Reply with quote

we are not allowed to change the table
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Thu Jul 24, 2008 3:21 pm
Reply with quote

well, faced with a wall of utter incompetence and stupidity,
it looks like you are going to have to resort
to varchar and char columns to store the dbcs data,
the same way fools store decimal and binary numerics.

I would suggest you talk to a dba about this.
any dba will recognize the need for inclusion
of proper datatype columns.
If this does not work, refer to my first suggestion.
Back to top
View user's profile Send private message
rpuhlman

New User


Joined: 11 Jun 2007
Posts: 80
Location: Columbus, Ohio

PostPosted: Thu Jul 24, 2008 3:39 pm
Reply with quote

Sailaja,

Does the requestor/user realize that you are not "allowed" to change the table structure? Who has placed this constraint on you? In other words, have you brought this to anyones attention? DBAs? User(s)? Supervisor? Have you put together any kind of written analysis to present your case and show what it's going to take to meet the requested requirement(s)? It seems to me that there is a major communication gap with this request. You need to ask questions of those involved.

Rick
Back to top
View user's profile Send private message
sailaja cherla

New User


Joined: 08 Oct 2007
Posts: 13
Location: India

PostPosted: Thu Jul 24, 2008 5:15 pm
Reply with quote

Rick,

This has been brought to attention of DBA's but they are saying that this could be possible.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jul 24, 2008 8:50 pm
Reply with quote

Hello,

Quote:
This has been brought to attention of DBA's but they are saying that this could be possible.
Many things are possible that should still not be done. . .

If the system truly has a dbcs requirement, the database should be changed rather than some cludge work-around be used.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Fri Jul 25, 2008 4:07 am
Reply with quote

if your company intends on keeping this customer, you are forced, technically, to move beyond 1900's technology and start dealing with dbcs - unicode.


your terminal serving cics region could route any customer to the region that has a database setup with unicode.

if management has decided that the money is not going to be spent to buy a copy of a less than 20 year old copy of db2, then you are in for the technical nightmare / thrilling-ride of your life.
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

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts 10 byte RBA conversion DB2 2
Search our Forums:

Back to Top