unable to convert code page 500 to code page 1255

Hi

i have a db2 version 7 on z/OS
in the past, the db2 ccsid parameter in dsnhdecp was 500,
at one point in time that parameter was changed to 424
so right now i have a db2 with ccsid 424 in dsnhdecp, and i have some tablespaces defined prior to the change thus using code page 500, and some tablespaces defined after the change thus using code page 424

i have installed udb and information integrator on a windows 2000 server, and i am attempting to access my zOs db2.
when i'm trying to retreive data from the 424 tablespaces, it works fine
when i'm tryint to retreive data from the 500 tablespaces, i get a message - can not convert from ccsid 500 to 1255

i tried to change the db2 ccsid parameter back to 500 loading sysibm.sysstrings with a translation from 500 to 1255 - still does not work

i tried using the zos conversion services defining a conversion between 500 to 1255, and between 500 to 1208 and 1208 to 1255 - still don't work

i tried to write my own conversion table, but when i did that, i got the text out of the 500 tablespace in reverse order (since i'm using hebrew data, the strings must be reversed when sent to windows because of logical / visual issues)

maybe someone has an idea i havn't tried yet ?

thanks
momiStart Free Trial