RE: Ops Nav, Run SQL Script: Commitment Control

Mark,

You had the key (isolation level) to my solution.  Thanks!  I used something
similar to the following.

Stan

set transaction isolation level read committed;
insert into file1 select * from filea where ...;
insert into file2 select * from fileb where ...;
-- verified my results --
commit;

-----Original Message-----
From: M. Lazarus [mailto:mlazarus@ttec.com]
Sent: Thursday, 29 March, 2001 6:42 PM
To: MIDRANGE-L@midrange.com
Subject: RE: Ops Nav, Run SQL Script: Commitment Control


Stan,

  You can add WITH NC at the end of the statement to turn of commitment 
control for that statement.

  -mark


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---