If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Displaying DBCS data in DB2 z/OS 7.1

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-27-06, 12:43
mlc465782 mlc465782 is offline
Registered User
 
Join Date: Mar 2006
Posts: 2
Question Displaying DBCS data in DB2 z/OS 7.1

I have a project which entails being able to view English and Japanese data within a table to the Japanese customer. We are running DB2 for z/OS V7.1 with codepage EBCDIC (0037) MIXED DATA=NO and these parms cannot be changed. We attempted to create the database and objects as unicode but ran into a lot of problems, so ultimately we recreated as EBCDIC and used 'for bit data' on the character fields which could contain DBCS data (also expanding the fields). This has worked at other places successfully.

In this case, the customer will come directly through MVS and QMF. I believe in order to properly see the data, some change has to be made on the user's terminal. Can anyone point me in the right direction? Everyone associated with the previous projects is long gone.

Thanks.
Reply With Quote
  #2 (permalink)  
Old 03-27-06, 15:28
schintala schintala is offline
Registered User
 
Join Date: Apr 2005
Location: USA
Posts: 119
You will have to change the settings to your z/OS terminal in order to view the data through MVS QMF. BTW, what emulator software you use to logon TSO. You can view these settings in the session configuration and look for 3270 emulation. There you will see the language and bla bla.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On