FOREACH problem in SPL

Hi, I'm very new to informix and I try to write simple test procedure that return multi rows value to the caller. I tried : create function func1(c1 varchar(255)) returning person_t2; define ret person_t2; FOREACH cur1 FOR SELECT c2 into ret FROM foo7; return ret WITH RESUME; END FOREACH end function but it fails with syntax error that I was not able to figure out myself(table foo7 and type person_t2 exists and having the correct types - c2 column is from type person_t2 ). The problem happend only when I have the FOREACH loop. Otherwise it works. Any idea ? Thanks, Gil

Gil Lapid wrote: > I'm very new to informix and I try to write simple test procedure that > return multi rows value to the caller. I tried: > > create function func1(c1 varchar(255)) returning person_t2;> define ret person_t2; > FOREACH cur1 FOR > SELECT c2 into ret FROM foo7; > return ret WITH RESUME; > END FOREACH > end function > > > but it fails with syntax error that I was not able to figure out > myself(table foo7 and type person_t2 exists and having the correct > types - c2 column is from type person_t2 ). > > The problem happend only when I have the FOREACH loop. Otherwise it > works. Semi-colons in SPL are an endless source of frustration. I think you need one after END FOREACH and you don't need one after FROM foo7, but I'd have to run the stuff through the server to be sure.