RE: do this test for me please.

I get the same error on SCO_SV, informix 7.30. (using dirty read) Just to add to the weirdness, this works: select partnum from systabnames order by 1 but this gives the error: select partnum from systabnames order by 1 desc Suppose it has anything to do with systabnames being an SMI pseudo-table? (BTW, the manual says that, since the SMI tables are created dynamically from shared memory, the isolation level is irrelevant, being essentially permanently dirty read) > -----Original Message----- > From: Rudy Fernandes [SMTP:rferdy@americasm01.nt.com] > Sent: Wednesday, November 03, 1999 11:38 AM > To: informix-list@iiug.org > Subject: Re: do this test for me please. > > I do not get the error in a test instance of mine (with multiple users > connected) [HP 10.20 v7.31uc2]. > > Maybe you can try either of the following : > > set isolation to dirty read;> select max(partnum) ... > > or > > select max(...) ... for read only > > Your problem seems to be related to ERWIN (as per your previous post). > Could there be a global option in ERWIN to do 'dirty reads'? > > Rudy > > samir BADAOUI wrote: > > > 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