Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB2: Using NOT EXISTS with SYSIBM.DUAL in a complex batch query

vicky chauhan
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,

I have data in a java object as data1, data2.

data1 and data2 together forms a composite key in myTable where I want to insert the object.

The writing is happening as a batch. Like 10 insert statements are prepared using 10 objects and are executed as a batch.

I want to insert the above data with the constraint: data1 + data2 should not already be present in myTable i.e. data1 + data2 should be unique --- if unique then write else just ignore.

The query I am using is:

Running above query independently for single set of data runs successfully.

However, while running in batch scenario I am getting " Non-atomic batch failure." error.

I think it has something to do with using SYSIBM.DUAL in batch scenario.

Please help!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic