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") :

$>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 - 08:15:03 CDT

Original text of this message