Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 double byte data in a non DBCS table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: DB2 double byte data in a non DBCS table
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

Site Director


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

PostPosted: Thu Jul 24, 2008 1:08 pm    Post subject:
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    Post subject:
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: 6970
Location: porcelain throne

PostPosted: Thu Jul 24, 2008 3:21 pm    Post subject:
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    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Thu Jul 24, 2008 8:50 pm    Post subject:
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: 6970
Location: porcelain throne

PostPosted: Fri Jul 25, 2008 4:07 am    Post subject: Reply to: DB2 double byte data in a non DBCS table
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    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 Moving a COMP-3 Variable to a Numeric... ajayachander COBOL Programming 2 Thu Dec 14, 2017 5:46 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts Fetching data from JHS as per the cur... arunsoods All Other Mainframe Topics 4 Wed Nov 22, 2017 1:54 pm
No new posts Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm
No new posts Updating data from one file to other!!! Vignesh Sid SYNCSORT 1 Mon Nov 06, 2017 2:42 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us