473,466 Members | 1,405 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

[DB2] Erreur CLI0102E Invalid conversion. SQLSTATE=07006

Hello,

I want to copy an application that run ok on my computer to another PC
but when I run the program (C#) on this computer, I receive the
message as define in the subject. This message is displayed on an SQL
command as SELECT ch1,ch2,ch3,... from tbl where id=123
It's due to the presence of a field with CLOB data type in the select
sentence.
The same SQL command run properly in the DB2 command prompt window.

It's a problem with CLI (OLEDB driver).

On my computer I have the version 7.01.00.55

On the other computer it's a most recent version (7.01.00.93)

Thanks for your help.
Nov 12 '05 #1
0 5834

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: HABJAN ®iga | last post by:
I'am trying to insert a record with a blob field in it: create table KC113DELO.Test1( ID INT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE ), TTEST...
1
by: Silke Stuehler | last post by:
I have a problem while colling the dxxGenXML() method. I got the following error: SQL0301N The value of input host variable or parameter number "1" cannot be used because of its data type. ...
3
by: JDPope | last post by:
I have a situation which I cannot get a good lead on how to resolve. One of the applications I support uses the Hibernate software to generate SQL. The app is JAVA with JDBC. In testing the users...
0
by: bughunter | last post by:
I found code from java - real bug with secondary parameter, should be Integer but called with String, But procedure completed without any errors and parameter correctly transformed to integer! ...
0
by: Alberto Salvati | last post by:
Hi, all. I'm a delphi developer who is working on a very old delphi application that uses db2v7 via ADO (Mdac). I know that v7 is very, very old, but at this moment, we cant' upgrade to a...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
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...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
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,...
0
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...
0
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...
0
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 ...

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.