Mark A wrote:
"Thames" <zh*****@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com... Hi,
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
Did you read the Message and Codes Vol 2 manual for that error message?
One can also get the error message on the command line:
--------------------------------------------------------------------
$ db2 "? sql0332"
SQL0332N There is no available conversion for the source code
page "<code-page>" to the target code page
"<code-page>". Reason code "<reason-code>".
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.
User Response:
Possible solutions include:
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 .
o Data conversion for some code page combinations may be
supported through database manager install options, depending
on the language group of the source or target code page.
Ensure that the appropriate ones are installed and accessible
to the database manager and the client application, as
indicated by the reason code returned. For a list of install
options, consult the Quick Beginnings or the DB2 Connect
Quick Beginnings .
o Data conversion for some code page combinations may be
supported by the database manager through an operating
system-provided character conversion utility, depending on
the language group of the source or target code page. Check
your operating system documentation for a list of supported
conversions and ensure that the appropriate ones are
installed and accessible to the database manager and the
client application, as indicated by the reason code returned.
For a list of operating system conversion utilities used,
consult the Quick Beginnings or the DB2 Connect Quick
Beginnings .
o Change the unsupported code page(s) to one of the documented
pairs.
AS/400 users should be aware that AS/400 CCSID 65535 is not
supported. AS/400 data encoded using CCSID 65535 must be
converted to a supported CCSID before it can be accessed using
DB2 Connect.
Federated system users: for data source code page support, see
the Federated Systems Guide .
sqlcode : -332
sqlstate : 57017
--------------------------------------------------------------------
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.
--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena