Re: Error Num -229

Bill Gauvey <bgauvey@loki.k12.ar.us> wrote: :Program stopped at "my4gl.4gl", line number 52. :SQL statement error number -229. :Could not open or create a temporary file. :Why can I not create this temp file? :DBTEMP is set to HOMEDIR$/tmp :Changed DBTEMP to INFORMIXDIR$/tmp and :no success. You would normally set DBTEMP to /tmp or some other fixed directory on a device with enough space. :.....and YES I have permissions. :lineno. 52 is... : FOREACH c_1 INTO pa_1.* :where pa_1 is an array with 6 items An array? It should be a record. If it's an array of records your syntax would be something like FOREACH c_1 INTO pa_1[1].* But this is not your problem. :and c_1 is a CURSOR FOR : SELECT * FROM tb_1 :NOTE: tb_1 has some 400,000 active records. :is this to large of a select? That may indeed be your problem. There may not be enough space on the device where your temporary table is created. Log in another time and check the available space as this foreach is executed. :should I break it down into sets? You may also check your select statement. If it is indeed what you give above (a simple select from one table with no where clause) no temporary table should be generated and I don't immediately understand why you get the error you do. If there is realy something more (an order by on a non indexed row perhaps?) a temporary table may easily be generated and there may not be enough space for it. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org