RE: Ececute procedure on each row

Posted in 2006

Alexey Sonkin — Wed, 26 Jul 2006 15:06:26 -0400 — source: Usenet: comp.databases.informix

If your procedure is actually a function, you should be able to do smth like SELECT my_procedure(l_acc_nr, l_settle_nr, l_nat_amount, l_s_nat_amount) FROM tmp_outstand -Alexey > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] > On Behalf Of maxskalski@gmail.com > Sent: Tuesday, July 25, 2006 8:27 PM > To: informix-list@iiug.org > Subject: Ececute procedure on each row > > Hi, > I have temp table: > > tmp_outstand > acc_nr integer > settle_nr integer > nat_amount decimal(16,2) > s_nat_amount decimal(16,2) > > Is there any way to execute procedure for each row of this temp table > (avoiding CURSOR)? > This procedure is quite complicated but in short: > > It takes as parameters 4 variables (one row from tmp_outstand) > > e.g. my_procedure(l_acc_nr, l_settle_nr, l_nat_amount, l_s_nat_amount) > > and it updates other table depending on data from tmp_outstand. > Procedure does not return any variable. > > Thanks in advance for any help, > Max > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list