making sure that one update statement update only one row
Posted: Tue Oct 28, 2008 2:20 pm
I have a job set up like
Dataset------------->transformer--------->Oracle stage.
I update some columns using key columns in the oracle tables (upsert). Can you please let me know, if there is anyway to make sure that each update statement updates only one row. I know that if the keys are unique it will update only one row. But just to want to make sure....Is there a way we can up in the datastage? which lets us know that a particular update statement updated more that one row?
Thanks
Dataset------------->transformer--------->Oracle stage.
I update some columns using key columns in the oracle tables (upsert). Can you please let me know, if there is anyway to make sure that each update statement updates only one row. I know that if the keys are unique it will update only one row. But just to want to make sure....Is there a way we can up in the datastage? which lets us know that a particular update statement updated more that one row?
Thanks