RE: Update daily one row of a while table

Jacques I am confused? You want to update a single row on a table, Yes. If so you only require 1 lock for the data row and 1 lock for each index. Do you mean you want to update one column on the entire table? If so you need to revisit you design !! :-) What exactly is the error you are encountering. Keith -> -----Original Message----- -> From: jacques.sanson@ferma.fr [mailto:jacques.sanson@ferma.fr] -> Sent: Tuesday, April 20, 2004 8:03 AM -> To: informix-list@iiug.org -> Subject: Update daily one row of a while table -> -> -> Hi, -> -> I need to update one row of a whole table. -> The row is a daily counter, so it needs to be reset -> everyday. -> -> I need to do this on a very large table (1 to 10 million rows), -> which exceeds the maximum number of locks available, -> so a simple UPDATE statement will not do. -> -> A table lock will not do either, since this table needs -> to be accessible while this update is performed. -> -> Is there a ready solution for this (either in SQL or ESQL-C ?) -> with IDS 9.30.UC2 or above ? -> -> Thanks, -> --Jacques-- -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list