auto commit within an db2 sql file -
07-19-2010
, 08:15 AM
I'm wondering, whether the "nobody ...." comment in the following sql file
(which is called via "$>db2 -t -f sql") :
$>cat sql
-- BEGIN
delete from NEW
;
-- nobody should to read from NEW at this point
insert into NEW (select * from OLD)
;
--END
could be removed or if it is possible that somebody could read from table
NEW between the delete and insert statement. |