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

One of the guru's will have to tell you why, but I get the same error on both an HP-UX instance of 7.30 and an NT version of 7.30 (well, the NT doesn't display the error 245 -- but that could just be the wonderful NT Telnet interface). Tom 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

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

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

Problem here: HPUX10.20 and IDS 7.30.uc7. John Carlson Informix DBA WHSmith USA 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

samir BADAOUI wrote: > 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. Same error here under IDS 7.30UC6 on Siemens Reliant Unix 5.43C20. Regards, Richard -- +--------------------------+------------------------------------------+ | Dr. med Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-6110 | | Klinikum Grosshadern | FAX : +49-89-7095-6420 | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+

The same error on WG7.30TC2 on NT4.0 SP5

But no problems on IDS7.31TC2 on NT4 SP5 -- ********************************** Dmitry Bobrov mailto:demon@guta.ru

hi, I ran this query on IDS 7.32 and here's the result. select max(partnum) from sysmaster:informix.systabnames (max) 1048725 bye Mohammed Hanif Khan

uname -a UnixWare CEDBS 5 7.0.1 i386 x86at SCO UNIX_SVR5 onstat -VInformix Dynamic Server Version 7.30.UC2 Same problem. However this works : select max(partnum/1) from sysmaster:informix.systabnames Result = (max) 14680065.0000000 Redirecting the operation to a simple arithmetic function, I've used this approach before to work around other simliar problems ....... Mariusz Malogrosz 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