473,785 Members | 2,307 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 UDB V7: Ignoring a set of parameters problem

Hi,

In the CLI guide and reference i've read about the possibility of getting status
information when using arrays to input parameter values. This i've achieved as
described with the SQL_ATTR_PARAM_ STATUS_PTR attribute of the SQLSetStmtAttr( )
function.

I'm trying to do a bulk INSERT and if there are already records in the target
table, i want to update those records that were already present. Depending on
the status information just received i filled an SQLUSMALLINT* array with
SQL_PARAM_PROCE ED or SQL_PARAM_IGNOR E for telling DB2 (with the
SQL_ATTR_PARAM_ OPERATION_PTR attribute of SQLSetStmtAttr( )) which records to
ignore when executing the SQL statement for the bulk UPDATE. This is were the
problem arises, i can't seem to make this bulk UPDATE work correctly. I'm
getting error message: [IBM][CLI Driver][DB2/LINUX] SQL0100W No row was found
for FETCH, UPDATE or DELETE; or the result of a query is an empty table.
SQLSTATE=00000.

But the destination table isn't empty, i've checked this a thousand times. I
also put on the tracing and you can actually see what DB2 wants to execute,
which are the exact records that already are in the destination table. In the
attachment i've described the table's structure and content, furthermore i've
added the error from the DB2DIAG.LOG file and the tracings that DB2 has
generated while executing my program.

Does anybody has experience with this kind of bulk INSERT/UPDATE actions???
Can someone give me an example of how i should do this or tell me what i'm
overlooking here.

Thanks in advance!!!

Davy Faassen
Nov 12 '05 #1
0 2385

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

Similar topics

4
1356
by: Brano Zarnovican | last post by:
Hi ! If I define 'f' like this def f(a): print a then, the call with keywords f(1, optional=2)
33
2611
by: C# Learner | last post by:
Note ---- Please use a fixed-width font to view this, such as Courier New. Problem
4
4748
by: Srikanth | last post by:
Hi Can any one say how to check a hashtable by ignoring the case of key supplied. I want the following requirement It should not allow the user to do the following Hashtable table = new Hashtable(); a) table.Add("one",1); b) table.Add("One",1);
17
2168
by: Ben R. | last post by:
I'm reading about attribute classes and specifically, named versus positional parameters. Was this implimented instead of multiple constructors for flexibility or is there another reason I'm missing? -Ben
4
3001
by: Mike Dinnis | last post by:
Hi, I've been working through a number of turorials to try to learn more about retrieving data from a SQL database. I think i've mastered techniques where i create a sql string in the page and pass it to the Db and retrieveing data from a stored procedure, but I can't get the hang of parameters. I have a method where I can get the parameters passed to the sp but it doesn't want to return any results. Here's a copy of my code:
0
5680
by: info | last post by:
i researched for a while on the net and found that more people have this problem, but could not get an answer. i am very new to MySql. linux - feudora i log into mysql using "root" when i am in mysql, and i type any comand, like show databases, i get
1
2797
by: Don | last post by:
Hi all, So i may have painted myself into a corner, am I screwed? I'm developing a message board for a site I work on, fairly simple hierarchy. Topics -> Threads -> Posts. As such, I've written a custom site map provider for my breadcrumb control. Adding SiteMapNodes for my ViewThreads.aspx (see all the threads in a topic) is simple...
2
2629
by: Hexman | last post by:
Hello All, Well I'm stumped once more. Need some help. Writing a simple select and update program using VB.Net 2005 and an Access DB. I'm using parameters in my update statement and when trying to update a record, I get a "No value given for one or more parameters." error message. I use a Select with parameters and an Update with parameters. The select works fine. I thought I've tried everything (evidently not) to get this working. ...
0
2100
by: Xah Lee | last post by:
In this article, i explain how the use of bit masks is a hack in many imperative languages. Often, a function will need to take many True/False parameters. For example, suppose i have a function that can draw a rainbow, and each color of the rainbow can be turned on or off individually. My function specification can be of this form: “rainbow(red, orange, yellow, green, blue, violet, purple)”. Each parameter is a true or false value....
0
9489
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
10357
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
10162
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10101
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8988
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 projectplanning, coding, testing, and deploymentwithout 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...
0
5396
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
5528
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4063
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
3
2893
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.