Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / August 2005

Tip: Looking for answers? Try searching our database.

help me out

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Thames - 30 Aug 2005 13:16 GMT
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

thanks
Mark A - 30 Aug 2005 13:22 GMT
> Hi,
>
[quoted text clipped - 22 lines]
>
> thanks

Did you read the Message and Codes Vol 2 manual for that error message?
Knut Stolze - 30 Aug 2005 16:57 GMT
>> Hi,
>>
[quoted text clipped - 22 lines]
>
> 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.

Signature

Knut Stolze
Information Integration Development
IBM Germany / University of Jena

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.