I'm accessing a db2/400 system via Perl DBI and the DBD:B2 module, but
when I go to pull data out of any table that's not codepage 37 I get an
error that looks like this:

"BD:B2::st execute failed: [IBM][CLI Driver][AS] SQL0332N There is no
available conversion for the source code page "937" to the target code page
"1252". Reason Code "1". SQLSTATE=57017"

I understand why this is happening, but not how to remedy the situation. I
cannot change the codepage for the tables because they are storing
multilingual data. Can anyone give me any advice on how I can work around
this problem?

DB2 does not support connection between different language groups. 1252 is
Latin 1 and 937 is Traditional Chinese.

Can you change your client to Unicode? A Unicode client can connect to any
databases.

Sherman

"Dana Cordes" <dcordes@nhbb.com> wrote in message
news:1061221491.333495@nnrp1.phx1.gblx.net...
> I'm accessing a db2/400 system via Perl DBI and the DBD:B2 module, but
> when I go to pull data out of any table that's not codepage 37 I get an
> error that looks like this:
>
> "BD:B2::st execute failed: [IBM][CLI Driver][AS] SQL0332N There is no
> available conversion for the source code page "937" to the target code
page
> "1252". Reason Code "1". SQLSTATE=57017"
>
> I understand why this is happening, but not how to remedy the situation.
I
> cannot change the codepage for the tables because they are storing
> multilingual data. Can anyone give me any advice on how I can work around
> this problem?
>
>