We are updating some information in the Backend (SYBASE) database from a Legacy file.
(File to XI to JDBC).
We are able to Insert or update or Delete.
1) If I want to know how many rows were affected because of the above DML operations, how should I do
2) Also, I have the Transaction roll back in the JDBC adapter and if there is some issue with the Data then in the Run Time work Bench, my JDBC adapter shows the RED button(Which is OK), but in my message Monitoring my job indicates its a successful job. any idea how can we manage this situation.