Hello,
I have been trying to enter SQL statmenbts to DB2 control center command line.
I saw that user "Thames" wrote to you:
> I have to repost my question for help.
>
> Yesterday I set up two DB UDB ESE V8.2 server on linux and windows
> platform, respectively. Both servers have been connected without any
> problems
> However, It gave me such error when I tried to make db connection via
> command prompt(windows)
>
> db2 connect to sample
>
> --------------
> SQL0332N there is no available conversion for the source code page
> "1252" to the target code page "1386". reason Code "1" SQLSTATE=57017
> --------------
>
> The strange thing is I can still see sample database connected from
> control center and also there is no problem with db object access in
> control center
>
> Also I can connect this sample db (in windows) from remote linux server
> I really do not know why I cannot connect to db sample locally using
> windows command prompt
>
> thanks
you wrote to him about the reasons:
>Explanation:
>No conversion of data is supported from the source code page to
>the target code page. This error can occur under the following
>conditions:
>
>o An error has occurred executing an SQL statement. The data
>cannot be processed by the database manager.
>
>o An error has occurred when trying to import or export a WSF
>or an IXF file. The import or export will fail.
>
>o Federated system users: the data source does not support the
>specified code page conversion.
>
>o DB2 Connect users: both "source code page" and "target code
>page" may refer to a CCSID on the host or AS/400 system.
>
>o An error has occurred during conversion from the code page
>stored with the encrypted data to the target code page.
>
>
>
>The reason codes are as follows:
>
>
>1 source and target code page combination is not supported by
>the database manager.
>
>2 source and target code page combination is either not
>supported by the database manager or by the operating system
>character conversion utility on the client node.
>
>3 source and target code page combination is either not
>supported by the database manager or by the operating system
>character conversion utility on the server node.
and you wrote about the solutions:
>o Verify that data conversion between the source and target
>code page is supported by the database manager. For
>database manager code page support, check the Quick
>Beginnings . If DB2 Connect is being used, check the DB2
>Connect Quick Beginnings .
What is data base code support?How do I get to it?
>o Change the unsupported code page(s) to one of the documented
>pairs.
How do I get to the unsupported code page(s) to change them?
You also wrote:
>You should verify what kind of code page setting you use in the DB2 command
>window and which code page is set for the database.
How do I verify this kind of information?
Thanks,
Yoav
I have been trying to enter SQL statmenbts to DB2 control center command line.
I saw that user "Thames" wrote to you:
> I have to repost my question for help.
>
> Yesterday I set up two DB UDB ESE V8.2 server on linux and windows
> platform, respectively. Both servers have been connected without any
> problems
> However, It gave me such error when I tried to make db connection via
> command prompt(windows)
>
> db2 connect to sample
>
> --------------
> SQL0332N there is no available conversion for the source code page
> "1252" to the target code page "1386". reason Code "1" SQLSTATE=57017
> --------------
>
> The strange thing is I can still see sample database connected from
> control center and also there is no problem with db object access in
> control center
>
> Also I can connect this sample db (in windows) from remote linux server
> I really do not know why I cannot connect to db sample locally using
> windows command prompt
>
> thanks
you wrote to him about the reasons:
>Explanation:
>No conversion of data is supported from the source code page to
>the target code page. This error can occur under the following
>conditions:
>
>o An error has occurred executing an SQL statement. The data
>cannot be processed by the database manager.
>
>o An error has occurred when trying to import or export a WSF
>or an IXF file. The import or export will fail.
>
>o Federated system users: the data source does not support the
>specified code page conversion.
>
>o DB2 Connect users: both "source code page" and "target code
>page" may refer to a CCSID on the host or AS/400 system.
>
>o An error has occurred during conversion from the code page
>stored with the encrypted data to the target code page.
>
>
>
>The reason codes are as follows:
>
>
>1 source and target code page combination is not supported by
>the database manager.
>
>2 source and target code page combination is either not
>supported by the database manager or by the operating system
>character conversion utility on the client node.
>
>3 source and target code page combination is either not
>supported by the database manager or by the operating system
>character conversion utility on the server node.
and you wrote about the solutions:
>o Verify that data conversion between the source and target
>code page is supported by the database manager. For
>database manager code page support, check the Quick
>Beginnings . If DB2 Connect is being used, check the DB2
>Connect Quick Beginnings .
What is data base code support?How do I get to it?
>o Change the unsupported code page(s) to one of the documented
>pairs.
How do I get to the unsupported code page(s) to change them?
You also wrote:
>You should verify what kind of code page setting you use in the DB2 command
>window and which code page is set for the database.
How do I verify this kind of information?
Thanks,
Yoav