Could not open or create a temporary file.

Hi I´m new to informix and when trying to run a quite big query I´m receiving this error: Error: Could not open or create a temporary file. (State:S1000, Native Code: FFFFFF1B) I´m using IDS version 10.00.TC3TL How can I increase my temp space in order to let the query be run? This is the query: ======================================= SELECT iu.informe_id, p.num_historia, u.num_episodio, di.triaje_fecha, di.medico_fecha, cm.cm_fecha, decode( pr_ic_esta( iu.informe_id ), -1, 0, 1 ) as estadoIC, nvl( pr_ic_nume( iu.informe_id ), 0 ) as numIC, p.nombre, p.apellido1, p.apellido2, p.fecha_nacimiento, p.sexo, p.provincia, p.poblacion, p.domicilio, p.telefono, p.movil, p.tis, p.pensionista, p.dni, u.fecha_hora_ingreso FROM V_V_PACIENTES p, V_V_URGENCIAS u, outer(t_v_informado_urge iu, OUTER t_v_datos_iniciale di, OUTER t_v_cierre_medico cm ) WHERE iu.informe_id = di.informe_id AND iu.informe_id = cm.informe_id and p.num_historia = u.num_historia AND u.num_historia = iu.num_historia AND u.num_episodio = iu.num_episodio AND u.fecha_hora_alta IS NULL =============================0 Thanks in advance Regards Guillermo

Looks to me your login/userid don't have permissions to write in the /tmp directory. By default the temp directory is /tmp. You can change this by using DBTEMP environment variable. Just set DBTEMP environment variable to the directory where you have write permissions or enough space. setenv DBTEMP /informix Regards, Ravikumar. GUILLERMO PENAGOS <gpenagos@cic-sl.es> wrote: Hi I´m new to informix and when trying to run a quite big query I´m receiving this error: Error: Could not open or create a temporary file. (State:S1000, Native Code: FFFFFF1B) I´m using IDS version 10.00.TC3TL How can I increase my temp space in order to let the query be run? This is the query: ======================================= SELECT iu.informe_id, p.num_historia, u.num_episodio, di.triaje_fecha, di.medico_fecha, cm.cm_fecha, decode( pr_ic_esta( iu.informe_id ), -1, 0, 1 ) as estadoIC, nvl( pr_ic_nume( iu.informe_id ), 0 ) as numIC, p.nombre, p.apellido1, p.apellido2, p.fecha_nacimiento, p.sexo, p.provincia, p.poblacion, p.domicilio, p.telefono, p.movil, p.tis, p.pensionista, p.dni, u.fecha_hora_ingreso FROM V_V_PACIENTES p, V_V_URGENCIAS u, outer(t_v_informado_urge iu, OUTER t_v_datos_iniciale di, OUTER t_v_cierre_medico cm ) WHERE iu.informe_id = di.informe_id AND iu.informe_id = cm.informe_id and p.num_historia = u.num_historia AND u.num_historia = iu.num_historia AND u.num_episodio = iu.num_episodio AND u.fecha_hora_alta IS NULL =============================0 Thanks in advance Regards Guillermo ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Here’s a new way to find what you're looking for - Yahoo! Answers