[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: A question about database commits...
Thanks to everyone who helped with this one. Since the database is
Oracle 7.3, from the input I have received here I should not have a
problem. I will explicitly start a transaction when starting to
process the file and then explicitly commit or rollback that
transaction just before I close the file and open another. I was just
worried that half way through a file, since I am effectively creating
entries one field at a time, if there was a problem I might end up
with some REALLY funky data. And since the database I am loading this
data into is HIGHLY relational, funky data is a recipe for all kinds
of headaches...
Alex