Re: Problems running isql from a daemon

>From: chip@osh3.OSHA.GOV (Charles Yamasaki) >Subject: Problems running isql from a daemon >Date: Tue, 12 Jul 1994 14:47:38 GMT >X-Informix-List-Id: <news.7571> > >I have an SQL query that I'd like to run from my HTTP server. When I >try to run isql from a CGI script the isql command finishes the query, >then just sits there indefinitely ringing up cpu time. Run from the >command line it works fine. I know the query is running because if I >kill the isql process I see that data was delivered. Any ideas? You don't say how you are running the query. I have not seen any problems when the query is run using one of the command modes: isql dbname script isql dbname - isql - script isql - - When the script argument is '-', isql reads from standard input; this could be the output of some other command piped into isql, or it could be redirected from a file, or it could be a here-document in the shell script. If you are trying to use "isql dbname -qr script", and especially if you're trying to "isql dbname -qr script1 -qr script2" then there could easily be problems of the sort you are referring to. Workaround: use the safe methods. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>