Re: Error Num -229

This is a multi-part message in MIME format. --------------7D3D6804681D Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bill Gauvey 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. > .....and YES I have permissions. > > lineno. 52 is... > FOREACH c_1 INTO pa_1.* > > where pa_1 is an array with 6 items > 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? > should I break it down into sets? Is this SE? Is it a SCROLL CURSOR? What is the ISAM error number? You should not have to break up the select, it sounds like a resource problem rather than a logic one. I presume the disk is not full. If this is OnLine, then is the dbspace full? Cheers, -- --------------7D3D6804681D Content-Type: text/plain; charset=us-ascii; name="ATT_SIG.TXT" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="ATT_SIG.TXT" Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+ --------------7D3D6804681D--