topic Re: Update table without locking it in Application Development and Automation Discussions

Update table without locking it

Former Member — Tue, 29 Jul 2008 09:58:46 GMT

Hi Guys,

I need to update a Z-table (create/change entries) through one z-program and dont want to lock the table while updating.

what would be the best approach to perform this task.

Regards,

Prashant

Re: Update table without locking it

vinod_vemuru2 — Tue, 29 Jul 2008 10:02:56 GMT

Hi,

If u don't want to lock the table then nothing special to do. Directly update the table using INSERT/MODIFY/UPDATE statements in ur zprogram.

INSERT ztable FROM TABLE i_ztable. " If the data is new always. i.e. i_ztable don't have records in Ztable.

MODIFY ztable FROM TABLE i_ztable. " If data is combination of existing and new records.i.e. i_ztable might have records in Ztable

Hope it helps.

Thanks,

Vinod.

Re: Update table without locking it

former_member182354 — Tue, 29 Jul 2008 10:04:18 GMT

Hi,

Use update command.

Raghav

Re: Update table without locking it

Former Member — Tue, 29 Jul 2008 10:09:31 GMT

Dont use END-OF-SELECTION in the program

regrasrd

rajesh

Re: Update table without locking it

Former Member — Tue, 29 Jul 2008 10:10:53 GMT

hiii

use from following query

-> UPDATE dbtab SET f1 ... fn.

-> UPDATE dbtab.

UPDATE *dbtab.

UPDATE (dbtabname)

-> UPDATE dbtab FROM TABLE i_tab.

UPDATE (dbtabname) FROM TABLE i_tab.

if you have used Insert statement then use MODIFY statement

-> MODIFY dbtab FROM wa.

-> MODIFY (dbtabname) FROM wa.

-> MODIFY dbtab FROM TABLE itab.

-> MODIFY dbtab

regards

twinkal

Re: Update table without locking it

Former Member — Tue, 29 Jul 2008 11:21:09 GMT

Hi,

Use INSERT, MODIFY,UPDATE statements for update table

or insert data into table via internal table.

Use sy-subrc check for each updation/modification/insertion.

This is only for z-tables only.For standard table don't do these hings.U can load the data using table maintenance generator also.

Regards,

Naveen.

Re: Update table without locking it

Former Member — Tue, 29 Jul 2008 11:24:06 GMT


> Dont use END-OF-SELECTION in the program
> 
> regrasrd
> 
> rajesh

Why not?! What has that got to do with updating a table with or without locking it?!