topic Re: commit in Application Development and Automation Discussions

commit

Former Member — Thu, 14 Feb 2008 17:39:32 GMT

please tell me

if i place commit in select and endselect . what happens?

regards

satish

Re: commit

former_member156446 — Thu, 14 Feb 2008 17:42:33 GMT

comit work will complete the update process which you did in a LUW.. if you dont have any LUW.. by the time comit work is hit.. nothing happens...

search in forums for LUW...

Re: commit

Former Member — Thu, 14 Feb 2008 18:31:25 GMT

Jay - don't really understand your answer.

But if you put a COMMIT inside SELECT/ENDSELECT, you will get a run time error.

Rob

Re: commit

Former Member — Mon, 23 Feb 2009 09:07:42 GMT

why are we getting error?

Re: commit

kamesh_g — Mon, 23 Feb 2009 09:13:29 GMT

if you use commit in select and endselect .

Every time you are committing the database such that updation to database is over .

so if we gone thru select statement for 20 times you are committing the database 20 times .

means more pressure u r putting on DATABASE.

in such a way if we have gone through the select for more than 10 times or 10000 times in production ( AS select end select is like a LOOP) we are hitting database such many times .

so we must nit use commit in with in select to protect database from max hittings.