auto commit within an db2 sql file

From: Toralf Förster <>
Date: Mon, 19 Jul 2010 15:15:03 +0200
Message-ID: <i21j4n$9v7$>

I'm wondering, whether the "nobody ...." comment in the following sql file (which is called via "$>db2 -t -f sql") :

$>cat sql


                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

Original text of this message