I'm running a sql statement:
SELECT
prueba1.maq_id, prueba1.fot_cantidad, prueba1.fot_cantplanpro, prueba1.fot_cantcancel,
prueba2.ott_nroserie,
prueba3.dot_fecent, prueba3.dot_fecfab,
prueba4.web_id
FROM
((prueba1 prueba1 INNER JOIN prueba2 prueba2 ON
prueba1.ot_id = prueba2.ot_id AND
prueba1.dot_id = prueba2.dot_id)
LEFT OUTER JOIN prueba3 prueba3 ON
prueba1.ot_id = prueba3.ot_id AND
prueba1.dot_id = prueba3.dot_id)
LEFT OUTER JOIN prueba4 prueba4 ON
prueba1.ot_id = prueba4.ot_id AND
prueba1.dot_id = prueba4.dot_id
that returns 10.000 records,
I have de following error message: Could not write to a temporary file.
What could be the problem?

Marce

This query probably creates huge temporary files/tables implicitly.
Check your temporary dbspaces are large enough, defined as temporary and make sure they are defined in the DBSPACETEMP configuration parameter of you ONCONFIG-file. Eventualle set the environment variable DBTEMP to use some specific directory for temporary space just temporarily.

Should work

Koen