Re: Update daily one row of a whole table

Posted in 2004

Enor Mouspenis — Tue, 20 Apr 2004 12:03:31 +0100 — source: Usenet: comp.databases.informix

Jacques SANSON wrote: > 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 ? Am not sure, you are locking one row only, how this use more than one lock? -- Enor