Re: Error Num -229

Bill Gauvey <bgauvey@loki.k12.ar.us> wrote: :Nils Myklebust wrote: :> :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. :The SELECT Statement is actually as follows: Without having analysed this it looks like something that would generate a temporary table. It's very hard to avoid that consistently with this complex a select. I try to avoid this complex type of statements. Up through times the different Informix engines have also had significant problems doing smart reading from the database. Often multiple temporary tables may be generated, and a lot of space may be needed for them. It may be advantageous to select from as few tables as possible first (with into temp...), and then join with the result. :SELECT jc_jobdesc, cpja_job, cp_race, county, dst_campus, : sch_co, sch_dist, sch_num, sch_campus :FROM jobcode, cpja, cpdem, county, district, school :WHERE county.county_co = district.district_co AND : district.district_co = school.sch_co AND : district.district_dst = school.sch_dist AND : cpdem.cp_co = school.sch_co AND : cpdem.cp_dst = school.sch_dist AND : cpdem.cp_sch = school.sch_num AND : cpja.cpja_ssn = cpdem.cp_ssn AND : jobcode.jc_jobcode > "1020" AND : jobcode.jc_jobcode = cpja.cpja_job :ORDER BY sch_co, sch_dist, sch_num, cpja_job :KEYS are as follows: : TABLE | column :================================ :jobcode | jc_jobcode :---------------+---------------- :cpja | cpja_co : " | cpja_dst : " | cpja_sch : " | cpja_ssn : " | cpja_job :---------------+---------------- :cpdem | cp_co : " | cp_dst : " | cp_sch : " | cp_ssn :---------------+---------------- :school | sch_co : " | sch_dst : " | sch_num :---------------+---------------- :district | district_co : " | district_dst :---------------+---------------- :county | county_co 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