auto commit within an db2 sql file
From: Toralf Förster <toralf.foerster_at_gmx.de>
Date: Mon, 19 Jul 2010 15:15:03 +0200
Message-ID: <i21j4n$9v7$1_at_news.eternal-september.org>
I'm wondering, whether the "nobody ...." comment in the following sql file (which is called via "$>db2 -t -f sql") :
--END could be removed or if it is possible that somebody could read from table NEW between the delete and insert statement. Received on Mon Jul 19 2010 - 15:15:03 CEST
Date: Mon, 19 Jul 2010 15:15:03 +0200
Message-ID: <i21j4n$9v7$1_at_news.eternal-september.org>
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. Received on Mon Jul 19 2010 - 15:15:03 CEST