473,218 Members | 1,932 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,218 software developers and data experts.

DB2 error in DB2 control center

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:

>No conversion of data is supported from the source code page to
>the target code page. This error can occur under the following
>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
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?
Sep 25 '08 #1
0 3082

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Jack | last post by:
The following is the error: Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression 'ApplicantIntID ='. /subgrantapptest/ListSaved.asp, line...
by: Sean C. | last post by:
Helpful folks, I have recently migrated our test server, which runs Win NT 4, from V7.2 FP11 to V8.1.3. Just about everything works wondefully, except I am having major problems getting the...
by: Raed Sawalha | last post by:
I have the following table which i can not switcha to design view error message said Could not open in Design view. Quote values differently inside a '<% ...."value"... %>' block. and the...
by: tjonsek | last post by:
am working on code that will allow users to update data within the datagrid. I have come across a few problems, some of them I have been able to work out, but this last one is giving me trouble. ...
by: scoffer | last post by:
Hi all, I have a problem when I try to open the tables list on a database. I work with 8.2.0 Enterprise Edition. The control center return this error: SQL0104N E' stato trovato un token...
by: DC | last post by:
The problem I'm using the .NET GridView and FormView objects for the first time and im getting the error "An OleDbParameter with ParameterName '@ID' is not contained by this...
by: =?Utf-8?B?c3Jpbml2YXM=?= | last post by:
Hi All, I'm having a grid view(GridView1) with a hyperlink column.It's ID is Link1 I want to show a popup on hyperlink click. I'm using ajaxToolkit:ModalPopupExtender for that. But when i'm using...
by: Ty | last post by:
Hello all, I am creating a web site with Visual Stuido 2008. I am trying to use a java script file to create a busybox for login from this page http://blogs.crsw.com/mark/articles/642.aspx. I...
by: graphicssl | last post by:
Okay, so first of all, I'm a designer first and a light coder second (I'm only really trained with HTML and CSS). So I apologize for having to post about something that's probably super-trivial! ...
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.