Re: concurrency problems

Scott Myers writes (re concurrency problems) : > These errors are probably associated with trying to access rows that are > locked by another user. > > When you create tables with OnLine, the default is to use page level locking > (page size is typcially 2K bytes). To get row level locking you must > explicitly specify in your CREATE TABLE statement. If you are using page > level locking for the tables associated with these errors, you can use the > ALTER TABLE statement to change them to row level locking which should > reduce or eliminate concurrency problems.> > Scott Myers - Informix (uunet!infmx!scottm) I've never been able to get these to work: ALTER TABLE foo LOCK MODE ROW; ALTER TABLE foo LOCK MODE PAGE, ROW; Eventually I give up and do an ASCII unload, drop, create (lock mode row) and reload. What am I doing wrong ? The manual and '?' when on "New" in isql both give the syntax as above, so far as I can see ... (Versions I just tried are isql 4.00.UE1, Online 4.00.UE3 on a Fuji, isql 2.10.03K, Online 4.00.UH1 on a Pyramid). PS. Thanks to DAS for offering some *MUCH* better get_key() stuff. -- Cheers - Tony. ____________________________________________________________________________ Tony Heskett: theskett@lhr-sys.ssf-sys.dhl.com | Vox: (+44) 81 747 8330 DHL Systems : Kings House, Great West Road, TW8 9HS | Fax: (+44) 81 747 0875