473,327 Members | 1,920 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,327 software developers and data experts.

How can I be getting this message

I am getting the message:

[IBM][CLI Driver][DB2/LINUX] SQL0407N Assignment of a NULL value to a
NOT NULL column "TBSPACEID=2, TABLEID=113, COLNO=1" is not allowed.
SQLSTATE=23502

while running the statement:

MERGE INTO is2.ent_herdid t1
USING is2.animals t2
ON t2.bhid = t1.bhid
OR t2.assoc <> 'AN'
OR t2.tattoo IS NULL
WHEN NOT MATCHED THEN insert(herd_owner_id,herd_id,bhid)
VALUES(2,t2.tattoo,t2.bhid)
;

By looking in the appropriate syscat tables, I have determined it is
unhappy with a value assigned to t1.herd_id, which in t2.tattoo. The
merge statement explicitly requires that value to be NOT NULL. At least
I think so: the ON condition is negated by the NOT MATCHED clause. By
DeMorgan's Theorem NOT(a OR b OR c) is the same as NOT(a) AND NOT(b) AND
NOT(C). In the case at hand that translates to t2.bhid<>t1.bhid AND
t2.assoc='AN' AND t2.tattoo IS NOT NULL. Obviously I don't understand
something about the syntax or the semantics of the merge statement. Any
form of enlightenment, including RTFM (as long it points to a particular
place) would be greatly appreciated

Nov 12 '05 #1
0 1231

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

Similar topics

6
by: Wm | last post by:
I'm totally clueless on this one -- I'm getting 3 copies of every Email (in plain text, not HTML as expected), from a single mail() line... Can anyone tell me what might be causing the duplicates??...
11
by: Brett | last post by:
In Yahoo mail, I click the Inbox link and see my messages. If I view source, I don't have HTML which contains the URL of each message. The source HTML contains javascripting and framesets. This...
8
by: Rod | last post by:
I have been working with ASP.NET 1.1 for quite a while now. For some reason, opening some ASP.NET applications we wrote is producing the following error message: "The Web server reported...
9
by: Microsoft News Server | last post by:
Hi, I am currently having a problem with random, intermittent lock ups in my ASP.net application on our production server (99% CPU usage by 3 threads, indefinately). I currently use IIS Debug...
2
by: MSK | last post by:
Hi, Continued to my earlier post regaring "Breakpoints are not getting hit" , I have comeup with more input this time.. Kindly give me some idea. I am a newbie to .NET, recently I installed...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.