Re: C program & Stored Procedures

The only way I know you can do this in 5.01 is via a system call in your stored procedure. The C program may of course be an ESQL/C program that updates the database in any way you see fit. It woun't be fast however. In Universal Server this changes a lot. You may either write a datablade, or perhaps better a Java function executed by the new Java datablade. Jessica Kung <jesskung@brel.com> wrote: :Dear Netizens :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. :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. :Thanks in advance! and Have a good weekend! :Best Regards Nils.Myklebust@idg.no <- New E-mail adress NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company