Does anyone happen to know if transactions are used when importing tables?
I thought inserts use restricted transactions if one was not already
started.

Thanks


jr

James,

<< Does anyone happen to know if transactions are used when importing
tables?  >>

Yes, IMPORT TABLE uses an internal transaction on the target table that
flushes to disk according to the size of the table buffers defined for the
table.

--
Tim Young
Elevate Software
www.elevatesoft.com

This is the behavior I was seeing today while importing a multitude of =
tables:=20

Table1 gets the import and an after insert trigger that adds 1 record to =
Table2.
 1.. Launch 2 EDB Mgrs
 2.. Start the import of 1000+ records
 3.. Open the 2nd table in EDB Mgr2. The records are viewable while the =
records are being imported.
 4.. Open the 1st table. These records are not viewable until the =
import completes.
Because I'm in the middle of the transaction, I didn't think I should =
see any new records from a different server connection until after the =
transaction is committed. Am I mistaken? It almost looked like triggers =
weren't participating in the import transactions.


jr




"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in =
message =
news:CFFB0040-D194-49AF-BF5D-BBB64B97B1B7@news.elevatesoft.com...
> James,
>=20
> << Does anyone happen to know if transactions are used when importing=20
> tables?  >>
>=20
> Yes, IMPORT TABLE uses an internal transaction on the target table =
that=20
> flushes to disk according to the size of the table buffers defined for =
the=20
> table.
>=20
> --=20
> Tim Young
> Elevate Software
> www.elevatesoft.com=20
>=20
>

James,

<< Table1 gets the import and an after insert trigger that adds 1 record to
Table2.
 1.. Launch 2 EDB Mgrs
 2.. Start the import of 1000+ records
 3.. Open the 2nd table in EDB Mgr2. The records are viewable while the
records are being imported.
 4.. Open the 1st table. These records are not viewable until the import
completes.
Because I'm in the middle of the transaction, I didn't think I should see
any new records from a different server connection until after the
transaction is committed. Am I mistaken? It almost looked like triggers
weren't participating in the import transactions. >>

Imports only use an internal transaction on the table being imported.  If
you want multiple tables to be part of the ransaction, then you'll need to
start a transaction that explicitly does this.


--
Tim Young
Elevate Software
www.elevatesoft.com