topic Re: Commit work after select statement in Application Development and Automation Discussions

Commit work after select statement

Former Member — Mon, 11 Aug 2014 18:14:21 GMT

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

Re: Commit work after select statement

arthur_alvesteixeira — Mon, 11 Aug 2014 18:23:57 GMT

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

Re: Commit work after select statement

Former Member — Mon, 11 Aug 2014 18:49:37 GMT

Hello Sam

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

regards

Re: Commit work after select statement

arthur_alvesteixeira — Mon, 11 Aug 2014 18:50:12 GMT

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

Re: Commit work after select statement

Former Member — Mon, 11 Aug 2014 19:16:26 GMT

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

Re: Commit work after select statement

Former Member — Mon, 11 Aug 2014 19:49:36 GMT

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

Re: Commit work after select statement

Former Member — Mon, 11 Aug 2014 20:06:21 GMT

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

Thanks

Amit

Re: Commit work after select statement

Former Member — Tue, 12 Aug 2014 07:58:31 GMT

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

Re: Commit work after select statement

former_member112264 — Wed, 08 Oct 2014 13:29:59 GMT

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