Re: do this test for me please.
Good Morning I have tested the below line on an Alpha 2100 running 7.30 FC5
under Tru64 4.0d pk4 and got the same error
Nick Leonard
Systems Administrator
Poole Hospital NHS Trust
>>> "Nick Kataria" <kataria.nick@emeryworld.com> 11/03/99 06:42pm >>>
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 .! I also tried set isolation to dirty read
and select.. for read only but the problem remains.
And, when I tried the same thing on IDS 7.31 UC2, it worked fine - no
problem at all.
samir BADAOUI <samir_badaoui@hotmail.com> wrote in message
news:7vpjir$km3$1@news.xmission.com...
>
> 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
Hi,
Server Version : Latest Nightly Build of 7.3 server.
Platform : SunOS idcsun68 5.5.1 Generic_103640-24 sun4u sparc
SUNW,Ultra-1
Query : select max(partnum) from sysmaster:informix.systabnames;
Result : (max)
1048765
Works fine for me.
Regards,
Naresh
> samir BADAOUI <samir_badaoui@hotmail.com> wrote in message
> news:7vpjir$km3$1@news.xmission.com...
> >
> > 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