How to handle transaction in BASIC ROUTINE
Posted: Mon Apr 04, 2005 11:48 pm
Hi All
My requirement is to read a row from a table. Then I want to update it with a new value. But untill I update the row, it should not be updated by any other application....... I think if I can lock the row after reading , untill we update it ..this purpose is served....
OR I can do both the operations inside a transaction block as follows...
BEGING TRANSACTION
select * from table
then store the value in some file,
update the row
END TRANSACTION
Please suggest me how to achieve it in datastage. Can I write a Basic routine for that... Any sample routine available??
Regards
rubu
My requirement is to read a row from a table. Then I want to update it with a new value. But untill I update the row, it should not be updated by any other application....... I think if I can lock the row after reading , untill we update it ..this purpose is served....
OR I can do both the operations inside a transaction block as follows...
BEGING TRANSACTION
select * from table
then store the value in some file,
update the row
END TRANSACTION
Please suggest me how to achieve it in datastage. Can I write a Basic routine for that... Any sample routine available??
Regards
rubu