Re: error after altering tables

Sahrul Hidayat wrote: > > This is a multi-part message in MIME format. > > ------=_NextPart_000_01CF_01BDBEBC.2CF31860 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Hi, > > I'm facing a problem with my databasa, INFORMIX 7.24 on HP-UX 10.01. > Heading Y2K, we are going to convert our data, some of tables we alter = > to expanded the char space. We have some YEAR INDICATOR which this field = > is using CHARACTER type. Before the altering this field only have 2 = > (two) char, now we alter to be 4 (four). This field is only indicator, = > eq. "95", "96" and so on. > But now we got a problem, when we are trying to select these tables, = > which have this kind field, we cannot select this field, we have tried = > also using space, failed. > The error number is 750, mentioned we have to try UPDATE STATISTICS, > We tried UPD STAT, and then select again, STILL FAILED...??? You do not say what sub-version of 7.24 you have. There were problems with some early 7.24 versions and the code that creates the data distributions. You need to upgrade to 7.24UC5 or later. For now just UPDATE STATISTICS LOW FOR TABLE mytable DROP DISTRIBUTIONS; andeverything should start working again. Since you have altered the table and 7.24 does ALTERs in-place you might try forcing the table to complete the ALTER by doing: UPDATE mytable SET coln=coln; and then try to build distributions again. It's worth one try, but the ultimate solution is to upgrade. Art S. Kagel