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.