Re: Reading over locked rows

Joerg Spilker (Joerg.Spilker@p0.f0.n0.z0.aventure.teuto.de) wrote: : Hi, : i've a program which unload tables to an ascii file and updates a specific : column in the rows after they are written to the file. : Isolation mode is set to repeatable read to avoid rows to be written to the : file which are not committed. Sounds like overkill! : Everything was fine but if there are open transactions over some rows of a : table i got repeated errors in the range -242 to -246 (depends if the table is : indexed or not) until all transactions for this table are completed. Is there a : way to "jump" over the locked rows? Using Dirty Read would seem to be the obvious route. It would be more efficient to update your column before writing not after. : Greetings, Joerg -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.