Re: Problems with views?
Hi, Please, The view is referencing to another table in the same database ? Or is referencing to a table (or join tables) of another database ? If the second, the another database is informix , o other as DB2 ? Look if there is other application running a 'select' or 'update' or 'delete' rows of the referencing table in transaction or if the table has lock mode page or row. Best regards, mery christmas !! Roberto F. "Ian Logan" <ian.logan@straker.com> wrote in message news:<brn91u$j28$1@terabinaries.xmission.com>... > This is a multi-part message in MIME format. > > ------=_NextPart_000_003A_01C3C3E5.F75CFF60 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Hi > > I have a problem with our system which is yielding error -243. > > Platform: > Windows 2000 > Informix 9.21 TC6R1 > Single user development environment > VB6 front end > > Scenario: > Running a stored procedure which involves a view as part of a SELECT may > sometimes cause the error "Could not position within a table ((Temp = > table for > view))". If I either restart the instance or try again after a short = > while then > it runs fine. > > This error seems to be normally linked to issues with locks on a table = > but in > this instance I think it is views (and different ones at that). > > Any ideas anyone? I'd be glad of some assistance. > > Kind Regards > Ian Logan > Project Manager > Straker Systems Ltd > > ------=_NextPart_000_003A_01C3C3E5.F75CFF60 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META http-equiv=3DContent-Type content=3D"text/html; = > charset=3Diso-8859-1"> > <META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=3D#ffffff> > <DIV><FONT face=3DArial size=3D2>Hi<BR><BR>I have a problem with our = > system which is=20 > yielding error -243.<BR><BR>Platform:<BR>Windows 2000<BR>Informix 9.21=20 > TC6R1<BR>Single user development environment<BR>VB6 front=20 > end<BR><BR>Scenario:<BR>Running a stored procedure which involves a view = > as part=20 > of a SELECT may<BR>sometimes cause the error "Could not position within = > a table=20 > ((Temp table for<BR>view))". If I either restart the instance or try = > again after=20 > a short while then<BR>it runs fine.<BR><BR>This error seems to be = > normally=20 > linked to issues with locks on a table but in<BR>this instance I think = > it is=20 > views (and different ones at that).<BR><BR>Any ideas anyone? I'd be glad = > of some=20 > assistance.<BR><BR>Kind Regards<BR>Ian Logan<BR>Project = > Manager<BR>Straker=20 > Systems Ltd</FONT></DIV></BODY></HTML> > > ------=_NextPart_000_003A_01C3C3E5.F75CFF60-- > > sending to informix-list