[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