Re: Problems running isql from a daemon

In <3011q8$4a4@emory.mathcs.emory.edu> johnl@informix.com (Jonathan Leffler) writes: >>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. The "-" option does not seem to make a difference. It still just hangs. The version is: INFORMIX-SQL Version 4.00.UG2 Software Serial Number LEX#F187429 -- -----------------------+--------------------------------------------------- Charles "Chip" Yamasaki| The opinions expressed here are my own and are not chip@osh1.OSHA.GOV | supported or even generally accepted by OSHA. :-) -----------------------+---------------------------------------------------