RE: C program & Stored Procedures

Greg, I beg to differ. If your c program is an esql/c program then it is perfectly feasible = for it to poke data into a scratch table for the benefit of the calling = stored procedure.=20 Take a look at the "system" command in the manuals. In your stored = procedure if you wrap your "system" call with begin and end statements = you can use the "on exception" statement to handle non-zero exit = statuses from your esql/c program and use this to roll back any = transaction you might be in. All the best,=20 Pete Harris=20 Jessica Kung wrote: >=20 > Dear Netizens >=20 > I am trying to program an Informix stored procedure to call an = external C > program running on a HP9000 running HPUX 9.x. We are using Informix = Online > 5.01. The C program will return some results and update to the = Informix > databases as well. >=20 > Is this possible? Pls help to give me some tips on how this can be = done. I > will need to return some updates to Informix as well. >=20 > Thanks in advance! and Have a good weekend! >=20 > Best Regards Cant be done. Opinions expressed herein are my own and may not represent those of my = employer.