Re: ISAM error

In article 22052@informix.com, davek@informix.com (David Kosenko) writes: >Emanuel Kamdoum writes: >>Program stopped at "filename.4gl", line number 102. >>SQL statement error number -229. >>Could not open or create a temporary file. >>SYSTEM error number -125. >>ISAM error: can't use nfs> >It sounds like your database is located in an nfs-mounted filesystem. >Se does not allow you to work against tables in nfs-mounted (i.e. non-local) >filesystems. The SCROLL cursor is trying to create a temp table and doesn't put it where your database files are, rather it looks in the directory specified by $DBTEMP. Most likely the DBTEMP environment variable is not set, and defaulting to /tmp which, on Sun's, can be defined as a swap filesystem. This is similar to a filesystem built on a ram disk. When we do a stat() on the directory we find that it is not a normal filesystem and assume it is NFS. A good thing anyway as file locking doesn't work on swapfs. Set your DBTEMP to a real, local filesystem and all should be OK. Simon