Updated row in DB2 through SPUFI, can we undo this?

[Ashish Mathew]

Hi,

I have updated row in DB2 using SPUFI, now how can I revert these changes which I have just done? Is there a way to do it?

[Anuj Dhawan]

Short answer is - it depends. And it depends if the COMMIT is executed or not.

Remember SPUFi is a tool. In SPUFI, you can set the defaults where it will prompt you before COMMIT. I leave it on you to check where the option is located - however, you can select AUTOCOMMIT as '?' or 'N'. If you specify '?' SPUFI will ask you to commit at the end, where you can choose not to commit. But if you choose to COMMIT, running other SQL query using the "pre-COMMIT" values is the only solution I can think of.

[Ashish Mathew]

Thanks Anuj. Setting up AUTOCOMMIT as 'to 'N' is what I am using now.

[Anuj Dhawan]

Glad, you've got it working.

[enrico-sorichetti]

just remember that using AUTOCOMMIT N will lock the updated rows for the rest of the SPUFI session
or until You force a commit with the proper command

[Ashish Mathew]

Thanks enrico. You mean to it will lock the row for other users? But once the query is executed successfully, the COMMIT will happen automatically?

[enrico-sorichetti]

You mean to it will lock the row for other users?

YES

But once the query is executed successfully, the COMMIT will happen automatically?

we are in a loop here ...
if the commit happened automatically we would be back to the situation You wanted to avoid.

[Ashish Mathew]

yes... I forgot the main question in the process of learning..