RE: do this test for me please.
This gives me the same error on AIX 4.3.2 and IDS 7.30.uc6.
I am assuming that the engine is almost alway using this table.
Since there is always at least one record locked I would suggest
the following work around.
select partnum from sysmaster:informix.systabnames
into temp tmp_partnum;select max(partnum) from tmp_partnum;
This worked for me.
> -----Original Message-----
> From: samir BADAOUI [SMTP:samir_badaoui@hotmail.com]
> Sent: Wednesday, November 03, 1999 8:29 AM
> To: informix-list@iiug.org
> Subject: do this test for me please.
>
> Hi all,
> my databases are under informix 7.30 on AIX 4.3
> the following statement :
> select max(partnum) from sysmaster:informix.systabnames
> give me the next error
> 245: Could not position within a file via an index. 102: ISAM error:> illegal argument to ISAM function.
> so please if any one can execute this statement under informix 7.30
> and give me a anserfor the result of this statement.
> I am wating for you friends ..
>
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
Well, I got the same error on IDS 7.3 UC8 on Solaris 2.6. The SQL worked
well when I replaced max with min or avg or count(*) which suggest that the
table is not locked. It seems that we have a bug with max(partnum) on
sysmaster:informix.systabnames only. Max also works fine with tabname on
sysmaster:informix.systabnames .!
Link, David A. <DALink@West.com> wrote in message
news:7vpn3k$lqk$1@news.xmission.com...
>
> This gives me the same error on AIX 4.3.2 and IDS 7.30.uc6.
> I am assuming that the engine is almost alway using this table.
> Since there is always at least one record locked I would suggest
> the following work around.
>
> select partnum from sysmaster:informix.systabnames
> into temp tmp_partnum;> select max(partnum) from tmp_partnum;
>
> This worked for me.
>
> > -----Original Message-----
> > From: samir BADAOUI [SMTP:samir_badaoui@hotmail.com]
> > Sent: Wednesday, November 03, 1999 8:29 AM
> > To: informix-list@iiug.org
> > Subject: do this test for me please.
> >
> > Hi all,
> > my databases are under informix 7.30 on AIX 4.3
> > the following statement :
> > select max(partnum) from sysmaster:informix.systabnames
> > give me the next error
> > 245: Could not position within a file via an index. 102: ISAM error:> > illegal argument to ISAM function.
> > so please if any one can execute this statement under informix 7.30
> > and give me a anserfor the result of this statement.
> > I am wating for you friends ..
> >
> >
> >
> > ______________________________________________________
> > Get Your Private, Free Email at http://www.hotmail.com