Re: Dostats error

On Thu, 01 Apr 2004 09:08:54 -0500, Dale Gilbert wrote: What release of dostats do you have? I uploaded a fix to this a while ago. IB it happens when the first table (ie lowest tabid) is a view IMS. Anyway, if you do not have Source Revision 1.96 then download the latest from the IIUG. If you do have the latest, or the download does not fix the problem, send me, via direct email: dbschema -ss/myschema output, printout of systables contents (order by tabid) and syscolumns (order by tabid, colno) contents, and sysindexes (order by tabid, idxname) and I'll see what I can track down. Art S. Kagel > I am getting the following error while running dostats: > > sis_trades(MEDIUM)...SUCCESSFUL :(0 hrs 0 mins 2.129 Secs) > history_id(HIGH)... > Cannot Update statistics for table: sis_trades, column history_id; SQLCODE = > -352, ISAM = 0, POS = 46 > > The column history_id is not part of the sis_trades table. We are running > IDS 7.31.UD1 on Sun Solaris 6. Any ideas on this would be appreciated. > Thanks > > Dale R. Gilbert > Sr. Database Analyst > (310) 385-2125 > E-MAIL DISCLAIMER > Notice Regarding Entry of Orders: Please do not transmit orders regarding > your account(s) by e-mail. National Clearing Corp. will not accept orders > transmitted by e-mail, and National Clearing Corp. will not be responsible > for carrying out such orders. Notice Regarding Privacy and Confidentiality: > National Clearing Corp. reserves the right to monitor and review the content > of all e-mail communications sent and/or received by its employees. > > sending to informix-list