Re: Got error 243 : Could not position within a table table-name

In article <355FE6A2.7F1B@cpm.elex.co.il>, PCGRP Yakov Berkovitch 5055 <berko@cpm.elex.co.il> writes >Hi, > >when several processes are trying to update the same row in the same >table, i got the error 243. > What is the ISAM error code? It may not be a locking problem... >It's very strange, because this error seems related to an hardware error >(see finderr). But the table seems Ok because the oncheck utility didn't >detect a problem. >Also the program is designed like this: > - set lock mode to wait 100 > - select for update > - update row, >BUT the process got the error immediately. It didn't wait 100 seconds. > >My questions are: > - why the process didn't wait ? > - what can cause the error 243. > >My configuration is : Informix 7.20 on AIX 4.1.5. > >Thanks for any responses. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care