Update table without locking it

[Former Member]

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

[vinod_vemuru2]

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.

[former_member182354]

Hi,

Use update command.

Raghav

[Former Member]

Dont use END-OF-SELECTION in the program

regrasrd

rajesh

[Former Member]

>

> 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?!

[Former Member]

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

[Former Member]

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.