Commit work after select statement

[Former Member]

HI

In one of the cases I came across this syntax

select * from ....

commit work.

I know commit work closes the current LUW and opens new one, what is the correct benefit of writing commit work after select statement is fired on any table?
Thanks

[arthur_alvesteixeira]

Commit work is used when you update/modify the database.

[arthur_alvesteixeira]

Select statement only read data and doesn't make change in database to use commit work.

[Former Member]

Hello Sam

If there is no logic between these two statements (SELECT and COMMIT WORK) then I see no benefit from this logic.

regards

[Former Member]

Hi Sam,

Are there more statements written in the program above Select statement?

If yes, then it might be that some database update is happening in program and commit is used for them.

However, there is no effect if commit is put right after select statement.

You can move on top of select (if more code is present before select statement)or remove the commit statement.

Thanks

Amit

[Former Member]

Thanks all really speaking there are no other statements between just select and commit, strange , that is why I put this query.

[Former Member]

How developed this code? Can you contact the person who did this? Otherwise you can remove it I think.

Thanks

Amit

[Former Member]

Hi

Sometimes COMMIT is required for example to save data to SPOOL.

I would not remove the line if you do not know why it is there. However, in your own coding, do not use that kind of sequence. COMMIT is not needed after SELECT.

regards

[former_member112264]

Commit work is used to reset the time limit counter, e.g after a long time run select statement.