Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Question Unanswered: Could not write to a temporary file.

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    30

    Dbspacetemp

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •