I am trying to insert or Update rows in a Database.
File to XI to database(DB2).
The question I have is
1) I need to insert the row what I read from File into the DB if that row doesnot exists, if the row is already there then I need to Update that row in the database.
2) When I run my scenario, if there is a problem in the DB while Inserting or Updating, the error message is available only in my RTW, but my Message Monitoring shows the Successful flag and just by seeing the Message monitoring , I may fail to attend a Failure that happened earlier.
Please assist me.