Re: LOCK TABLE

Posted in 1996

"Dave K. Lahoti" — 25 Apr 1996 16:18:16 -0400 — source: Informix-list mailing list archive (1991-1998)

Maybe you might want to create a procedure. Something like. . . begin_work() { BEGIN WORK LOCK TABLE blah IN EXCLUSIVE MODE } main { begin_work() . . . . . . COMMIT WORK } Get the picture? Does anyone see a problem with this algorithmic approach? > > How can I lock a table during all the program ? > > If I use "LOCK TABLE IN EXCLUSIVE MODE", I only lock the table during the > transaction, but what happen if my program has "n" transactions, I must lock > the same table "n" times ? > > > -- +----------------+ | Dave K. Lahoti | == D4kLaho@PacBell.COM --- http://www.PacBell.COM +----------------+