RE: Update Statistics Error:-243 C-ISAM:-103

Posted in 1998

Alain Martin — Fri, 20 Feb 1998 09:17:44 -0500 — source: Informix-list mailing list archive (1991-1998)

I wrote: > Hi, > > I ran the update statistics accordingly to the recommandation of INFORMIX. But i got a error -243 C_ISAM:-> 103 with this one: > > UPDATE STATISTICS HIGH FOR TABLE toe1odi (a0071a_ord_no);> > The script had 2500 update statistics. All the others run fine except this one. > > Why? > > I tried SET LOCK MODE TO WAIT, SET ISOLATION TO DIRTY READ, no logging. Same error. > > I use INFORMIX-ONLINE 7.23. I got the answer. If a index is in diseable mode, you can't update statistics for that column. Hop this will help somebody else. Alain Martin INT Systemes d'Information Inc. alainmartin@POBoxes.com amartin@magrit.com