lock problem
Posted in 1999
Hi, coming from the Oracle world I focus a problem in my informix database. In a table with a lot of concurrent activities on that table (insert , update, select) and having a lot of rows the select very often runs into a lock and therefore can't proceed the select. How can I configure that reading the data is still possible or that the concerned row is omitted, and select proceeds with the next row? Any help is greatly appreciated. Antje Sackwitz ------------------------------------------------------------- Antje Sackwitz Phone +49-431-7109-514 Vossloh System-Technik GmbH Fax +49-431-7109-502 Edisonstr. 3 E-Mail sackwitz@vst.vossloh.de 24145 Kiel -------------------------------------------------------------