What happens if I try to delete many records and the database engine discovers, while deleting, that a record is locked by a user? For example, a table contains many thousands of records and 1000 of them meet a certain condition. I want to delete those records so I issue the command DELETE FOR that condition. After having deleted 800 of those 1000 records, the database engine encounters a record that is locked by a user. Does it automatically RECALL the 800 deleted records or do they remain deleted even though the command could not be completed successfully?
James McIlwrath
Datasmith Ltd.
250 Webb Drive, Suite 1206
Mississauga, ON L5B 3Z4
Canada
Phone:(905) 566-0766
Fax:(905) 566-4547
E-mail:
jmci@rogers.com