INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

joining tables with different code pages

joining tables with different code pages

(OP)
In my company all tables are configured to use codepage 243 (= EBCDIC German). Cp243 however doesn't support the euro-sign "€". This causes a problem in one particular table, where the users enter freetexts. Cp1141 was developed out of Cp243 to support the euro-sign. Both codepages are nearly identical. According to our DB2 expert there could be performance problems or that "strange" issues may occur, if we migrate only that particular table to Cp1141 and join it with other tables that are still using Cp243. Is it indeed an all or nothing issue? I really don't feel like changing numerous tables.

RE: joining tables with different code pages

Suggest you look at every byte in both CPages and make sure only the one value is different. And which value wil be forfieted if the Euro sign is included.

If the problem value is only entered in freetext, it would not participate in a JOIN would it?

RE: joining tables with different code pages

you can use different encoding within joins.

http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/in...

but performance will most likely be affected. I strongly advise that you test this in advance by creating one copy of the table in question with the desired CP, and then testing performance with production size data and using the normal queries used by your current prod environment.
Look not only at timing but at performance analysis, query plans and so on. use Insight or similar if you can.

On top of this and before you consider the change you need to go through all your JCL's and applications that connect to this table, either directly or through extracts and see what is the impact of changing it, both in terms of work to eventually change the software to deal with a difference cp on this table and in terms of functionality - some of the software that consumes the data on this table may already be applying some internal conversion to deal with the fact that a particular hex value corresponds to the euro symbol.

The work above is the same you would have to convert ALL tables to the Euro codepage. Extra work if you would do the full conversion would be to change DB default and to unload/load the data back to DB

Regards

Frederico Fonseca
SysSoft Integrated Ltd
www.syssoft-int.com

FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?

RE: joining tables with different code pages

(OP)
Thanks for the info. Basically it would be better to convert all tables, because the table that causes us problems is part of our purchasing and fact-sheet systems. Our sales, after-sales, calculation, marketing and some external systems all depend on it. For the moment I'll suggest a workaround solution (replace € by EUR) to the problem, until we find a sponsor for the CP conversion. We might then as well go ahead with Unicode, since we get more and more foreign clients that enter data that is not EBCDIC compliant.

Regards,

Tom van Breukelen

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close