Re: Reading over locked rows

} } 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. } } 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? Yes use Dirty Read Isolation level, this does negate the Repeatable read stuff but that is what you are asking when you ask to ignore locks. If you want to skip the records that are locked set lock mode to not wait and fetch the records testing for a lock...if you get one of the codes you indicated ...ignore it and fetch the next record. Mike } } Greetings, Joerg } }