aspose file tools
The moose likes JDBC and Relational Databases 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 Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 3708
    
  61

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.
 
Don't get me started about those stupid light bulbs.
 
subject: db2 SQL