I've read some facts about transaction handling / Locking.
I have a table ZPRICECOND_TAB that needs to be updated every 4 h.
Table ZPRICECOND_TAB has:
Primary key: 3
Other: runnig sqlserver2000 on windows.
So now I think I need to make the following statement.
delete from ZPRICECOND_TAB. " empty this table
insert ZPRICECOND_TAB from table i_pricecond3100.
insert ZPRICECOND_TAB from table i_pricecond4100.
Q1: How do I do a proper transaction/locking on this table ?
Dirty reads are OK... but there must always be data in the table...locks/waiting are ok as well...