While executing sql command in IBM db2 control center editor, I was getting error
SQL0332N Character conversion from the source code page "" to the target code page "" is not supported. SQLSTATE=57017
Searching for this, I found that I need t change the code page of the client to be the same as the table I am selecting from
To do this:
Open a command prompt
Go to C:\Program Files\IBM\SQLLIB\BIN\ or just make sure it exists in the windows %PATH%
Type db2set db2codepage=1208 then press enter
In my case the target codepage was 1208, it needs to be checked first before setting it
No comments:
Post a Comment