error after altering tables
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...??? Does anybody have this experienced or suggestion...????? Feedback would be greatly appreciated Sahrul ------=_NextPart_000_01CF_01BDBEBC.2CF31860 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type> <META content=3D'"MSHTML 4.72.2106.6"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT color=3D#000000 size=3D2>Hi,</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT size=3D2>I'm facing a problem with my databasa, INFORMIX 7.24 = on HP-UX=20 10.01.</FONT></DIV> <DIV><FONT size=3D2>Heading Y2K, we are going to convert our data, some = of tables=20 we alter to expanded the char space. We have some YEAR INDICATOR which = this=20 field is using CHARACTER type. Before the altering this field only have = 2 (two)=20 char, now we alter to be 4 (four). This field is only indicator, eq.=20 "95", "96" and so on.</FONT></DIV> <DIV><FONT size=3D2>But now we got a problem, when we are trying to = select these=20 tables, which have this kind field, we cannot select this field, we have = tried=20 also using space, failed.</FONT></DIV> <DIV><FONT size=3D2>The error number is 750, mentioned we have to try = UPDATE=20 STATISTICS,</FONT></DIV> <DIV><FONT size=3D2>We tried UPD STAT, and then select again, STILL=20 FAILED...???</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Does anybody have this experienced or=20 suggestion...?????</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV>Feedback would be greatly appreciated</DIV> <DIV> </DIV> <DIV><FONT color=3D#000000 size=3D2>Sahrul</FONT></DIV></BODY></HTML> ------=_NextPart_000_01CF_01BDBEBC.2CF31860--