Re: "load from" and stored procedures

From: Kate Juliff <kcj@mechoshade.com> > >Yes, I've tried with the system call directly to the program I wish to >run, the system call to a shell script that runs the program etc.. > >I do not get ant error at all from the SP. I am using Cold Fusion and >hacve set up the datsource with SDK. I call the procedure from Cold >Fusion and it never returns. There's just no error. > >To give detail > >If the SP just has a system call to the program >e.g. >let tmp = "/home/kcj/database/progname"; >system tmp; > >Then any call to the SP from Cold Fusion results in it hanging. > >If I have a shell script that contains only the program name with >redirected output >e.g. /home/kcj/database/progname > /home/kcj/tmp/blah > >Then I get an error message written to blah that says INFORMIXSERVER >must be set > >If I set INFORMIXSERVER in the shell script before I call the prgram, >it hangs. > >If I redirect the output in the string in the SP, it shows nothing (it >has hung). > >All the SPs work if called from within SE. > >All the scripts work if called from UNIX What happens if you run the SP from MS Query? Like EXECUTE PROCEDURE blah(1234)? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com