File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes db2 SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "db2 SQL" Watch "db2 SQL" New topic
Author

db2 SQL

Shiva.Om Kumar
Ranch Hand

Joined: Jun 14, 2010
Posts: 68
Hi,

I am not sure if this is appropriate forum to post this issue, but in case you have idea, please share your view,

I am trying to write db2 SQL (Merge statement),



Above SQL works till line 4, but if I run full statement, I am getting error 23505 - A violation of the constraint imposed by a unique index or a unique constraint occurred.
But there is no such record having id as PX.
If I run following, I am able to insert


Any clue what is the missing point
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3435
    
  47

How many rows are in the myTable table?

The WHEN NOT MATCHED clause will insert one row for every unmatched row in the source table. If there is more than one unmatched record, you'll get PK violation, because you are inserting constant values.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: db2 SQL
 
Similar Threads
I want to not allow to insert more than 4 records
JDO issue
How to control Ora errors in program
Oracle Query is not running
Error Help