commit

[Former Member]

please tell me

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

regards

satish

[former_member156446]

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...

[Former Member]

Jay - don't really understand your answer.

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

Rob

[Former Member]

why are we getting error?

[kamesh_g]

HI

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.