DB2: There is no available conversion for the source code page

x_globus · #1 (**permalink**) 12-14-09, 03:22 AM

I'm usind db2 8. Try to connect to the database (on the remotee computer, using vpn).
While connecting I have an error:

SQL0332N There is no available conversion for the source code page "1251" to
the target code page "UNKNOWN". Reason Code "1". SQLSTATE=57017

I tried to set DISABLEUNICODE=1 in db2cli.ini, and aslo tried to set db2set DB2CODEPAGE=1251. But it did not help.

What shall I do in order to connect to the database?

x_globus · #2 (**permalink**) 12-15-09, 07:58 AM

The problem is solved.
As database I wish to connect to is situated in US, I set DB2CODEPAGE=1252,
where 1252 is value for codepage in US.