473,796 Members | 2,728 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 error in DB2 control center

5 New Member
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
Sep 25 '08 #1
0 3123

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

Similar topics

2
1506
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 53 The following is the code: <script LANGUAGE="JavaScript">
1
3119
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 previously defined federated servers/nicknames to work. But I will start a different thread about that problem. I thought I'd ask about the less critical problem first. It deals with the Control Center and the following error: SQL0713N The...
12
2220
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 line which make the error is anchor but i cannot make it work. <TABLE id="tblDocList" dir="<%#strLangDir%>" style="DISPLAY:inline"
3
1582
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. When a user clicks the edit button, I get an error 'Specified Cast Not Valid'. The code that generates the error is: Dim strCompleted As String = CType(e.Item.Cells(6).Controls(1), TextBox).Text
3
2126
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 "SELECT TabSchema, Tabname, Type, T" non previsto dopo "BEGIN-OF-STATEMENT". I token previsti possono comprendere: "<query_expr_top>". SQLSTATE=42601
0
3588
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 OleDbParameterCollection" whenI try to write a new record. Delete and Modify work fine its just the add record function causes the error.
2
5682
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 TargetControlID="Link1" for ajaxToolkit:ModalPopupExtender I'm getting an error System.InvalidOperationException: The TargetControlID of 'ModalPopupExtender1' is not valid. A control with ID 'Link1' could not be found.
4
3877
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 am using a master page senerio. The erro I'm getting is 'busyBox' is not a member of 'ASP.login2_aspx'
3
3602
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! I'm working on setting up a shopping cart for a one-product web site, and I'm using HTML and CSS, with ASP for the shopping cart. The ASP takes the information from the form on the shopping cart, and formats it in to two e-mails: one for the company...
0
9685
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9535
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10467
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9061
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7558
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6802
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5454
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5582
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4130
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.