re: Could not write to temp file error

In article <1994Jan25.102415.13827@bilpin.co.uk>, ron@bilpin.co.uk writes: |> >(4GL= -264, ISAM= -107) |> >Could not write to a temporary file. |> >ISAM error: record is locked. |> Thanks for those who responded, but surely 'LOCATE blob_name IN MEMORY' |> means just that, locate in memory. It most certainly does. Your problem seems to have nothing to do with memory problems, but rather a lock is preventing the fetch from succeeding. I'm not sure why the -264 is cropping up. What is the full select statement? |> And if there is no space left in memory, then can we assume that Informix |> will try to write to /tmp/informix_assigned_file_name or |> $DBTEMP/informix_assigned_file_name file? No, you would get an 'out of memory' error. If you want it in memory, we will put it in memory or nowhere. Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney