Some of you has propably wanted to query the system tables and use this information in conjunction with logical information from customer tables.

On DB2 v 7.x on z/OS this is only possible as long as the system tables and the customer tables are stored in with the same character set.

In my case the system tables are stored in EBCDIC as per default, I don't think it is possible to change this. Q1 ?

Our customer tables are stored in ASCII. If I join an EBCDIC table and an ASCII table I get an error due to my description above. In my humble opinion, this should be possible, but perhaps with a little bit of help from a function. Any ideas / comments. Q2 ?


Thank you in advance.