Ok, thats waht I was looking for..

thanx , mike

-----Original Message-----
From: Doug Chamberlin [mailto:dchamberlin@...]
Sent: Thursday, August 16, 2001 1:39 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Importing Records


At 8/16/2001 02:42 PM (Thursday), Mike Grover wrote:

>so if i call a sql like this:
>INSERT INTO EXPERIAN SELECT * FROM EXP1;
>INSERT INTO EXPERIAN SELECT * FROM EXP2;
>INSERT INTO EXPERIAN SELECT * FROM EXP3;
>INSERT INTO EXPERIAN SELECT * FROM EXP4;
>etc...
>
>each will be in it's own transaction?

Only if you do

INSERT INTO EXPERIAN SELECT * FROM EXP1;
COMMIT;
INSERT INTO EXPERIAN SELECT * FROM EXP2;
COMMIT;
INSERT INTO EXPERIAN SELECT * FROM EXP3;
COMMIT;
INSERT INTO EXPERIAN SELECT * FROM EXP4;
COMMIT;

After each commit you will start a new txn.


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Do you need to encrypt all your online transactions? Secure corporate intranets? Authenticate your Web sites? Whatever
security your site needs, you'll find the perfect solution here!
http://us.click.yahoo.com/Bre3tC/Q56CAA/yigFAA/dpFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/