Does DB2 have an "insert or update" statement?
- by Mikael Eriksson
From my code (Java) I want to ensure that a row exists in the database (DB2) after my code is executed.
My code now does a select and if no result is returned it does an insert. I really don't like this code since it exposes me to concurrency issuses when running in a multi-threaded environment.
What I would like to do is to put this logic in DB2…