0 - 1 of 1 tags for access lock

Lot of our jobs needs to wait for some upstream tables that take a really long time to complete. We have some SLA's to be met
for our jobs and are OK with the data as of yesterday in these upstream tables.

Now, the problem is, the upstream tables have logics written as DELETE & INSERT (in the same BTEQ).

delete from DBNAME.TABLENAME
where UPI_COLUMNNAME in
( select UPI_COLUMNNAME
from DBNAME.INCR_DELTA_TABLENAME
)
;

insert into DBNAME.TABLENAME
(
COLUMN1,
COLUMN2
etc.,
)