Lock for Preventing other user from UPDATION

[Rubu]

Hi

I want to lock a row while reading until I update it in another stage of the same job. The requirement is like this.....

I have to read table ABC (col1, col2) where col1='xyz' and store col2 in a file.

Now, I want to update col2 of ABC table with a value col2+input1(a number). but my concern is meanwhile no other user should update col2 value .

Is there any way of achieving it in datastage.?
Shall I place a lock while reading and release it in update stage in database stage(informix)?

If yes...how can it be done?


Regards
Rubu

[roy]

Hi,
Yes, the only way to enshure no changes while you update would be to lock the record/s at hand, just check with your DBA if this might be achieved via you Isolation level (I think it can), if not you'll need to issue a lock statement.

IHTH,

[roy]

By the way,
how about:

Code: Select all

DB -> Xfm -> File
          -> DB

read the value in the Xfm write the original value to the file in one link and ion another link calculate and update the value.

IHTH