Informix Store Procedure Question

Posted in 2005

dorn b — Tue, 29 Mar 2005 00:46:18 — source: IIUG Forums & Mailing Lists

I currently have a web server connected to a informix database server through CSDK. I know it is possible to call a store procedure to execute a system command within a database server itself. However, I would like to know whether it is possible to call a store procedure from a web server to execute system command in the server that informix resides on; for instance, by writing a code in Perl or PHP. I wonder if anyone could guide me on this matter. Thank you. Regards, Dorn B.

↪ replying to dorn b

Jonathan Leffler — Tue, 29 Mar 2005 02:46:39 — source: IIUG Forums & Mailing Lists

Yes - if the web server can connect to the database, it can issue a request to execute a stored procedure. Build PHP with Informix. Build Perl and add DBI and DBD::Informix. -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Information Management Division 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" forum.subscriber@iiug.org wrote on 03/28/2005 04:46:23 PM: > I currently have a web server connected to a informix database server > through CSDK. > > I know it is possible to call a store procedure to execute a system > command within a database server itself. > > However, I would like to know whether it is possible to call a store > procedure from a web server to execute system command in the server > that informix resides on; for instance, by writing a code in Perl or > PHP. > > I wonder if anyone could guide me on this matter. Thank you. > > Regards, > Dorn B. >