topic Re: is it required to do COMMIT / ROLLBACK work while insert/delate/update Ztab in Application Development and Automation Discussions

is it required to do COMMIT / ROLLBACK work while insert/delate/update Ztab

Former Member — Mon, 24 Nov 2008 10:48:52 GMT

HI,

Is it required to to Commit / Roll back work while Inserting data into Ztable or Updating or deleting Ztables...

Thanks

Chinna

Re: is it required to do COMMIT / ROLLBACK work while insert/delate/update Ztab

Former Member — Mon, 24 Nov 2008 10:49:43 GMT

Itz not required, beacuse commit/rollback are done implicitly if u donot mention it.

But it is recommended to use commit/rollback explicity.

Re: is it required to do COMMIT / ROLLBACK work while insert/delate/update Ztab

Former Member — Mon, 24 Nov 2008 10:50:31 GMT

Hi,

It's not required. Even with the statement Insert,Update,delete...database will get updated.

Re: is it required to do COMMIT / ROLLBACK work while insert/delate/update Ztab

Former Member — Mon, 24 Nov 2008 10:52:30 GMT

Hi,

Please check

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3b64358411d1829f0000e829fbfe/content.htm

Re: is it required to do COMMIT / ROLLBACK work while insert/delate/update Ztab

Former Member — Mon, 24 Nov 2008 10:55:04 GMT

Hi,

I think it's not required... it will used only with sql statements....Querys..

Thanks,

ThiruKumaran. R

Re: is it required to do COMMIT / ROLLBACK work while insert/delate/update Ztab

Former Member — Mon, 24 Nov 2008 10:56:17 GMT

check this link:

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3b64358411d1829f0000e829fbfe/content.htm

Regards

Neha

Re: is it required to do COMMIT / ROLLBACK work while insert/delate/update Ztab

Former Member — Mon, 24 Nov 2008 10:58:02 GMT

Hi Chinna,

It is mandatory to COMMIT or ROlLBACK when you insert, update data in a Z table.You can fix a no of records after which you can fire COMMIT statement. it is not necessary to COMMIT each and evey record . You can COMMIT 'N ' no of records with a single COMMIT.

But you should take care that it dows not put load on Application server.

Thanks and regards

Sourabh

Re: is it required to do COMMIT / ROLLBACK work while insert/delate/update Ztab

christine_evans — Mon, 24 Nov 2008 12:20:40 GMT


> HI,
>   Is it required to to Commit / Roll back work while Inserting data into Ztable or Updating or deleting Ztables...
> 
> 
> Thanks
> Chinna

If you don't do an explicit commit / rollback in your program, when you exit your program the system will do the commit for you - this is one example of an implicit commit. Implicit commits will be activated at other points also eg when you call a popup screen.

Personally, I prefer to program commits and rollbacks myself and not rely on implicit commits.