Re: Executing SQL in the Background?

Jonathan! I'm shocked! I never thought you'd stoop to trolling!! :-) In the year of Our Lord Tue, 19 Dec 2000 21:53:15 GMT, Jonathan Leffler <jleffler@informix.com> broke a vow of silence to utter: >Obnoxio The Clown wrote: >> >> In the year of Our Lord Tue, 19 Dec 2000 18:51:28 GMT, Jonathan Leffler >> <jleffler@informix.com> broke a vow of silence to utter: >> >> >Ronald Cole wrote: >> >> "Obnoxio The Clown" <obnoxio@hotmail.com> writes: >> >> > Well, I just did a test, and it did seem to fire up "sub shells", however, >> >> > it looked like they were run sequentially, although it was hard to say that >> >> > it was a definitive test. :-) >> >> >> >> I believe dbaccess wait()s for the shell sub-processes to finish >> >> before interpreting the next command. >> > >> >But the ampersand at the end of each command tells the shell to run the >> >process in the background. Now, if the shell does not exit until its >> >children terminate, that is a separate problem, overcome by using: >> > >> >( dbaccess dbase scriptN.sql & ) >> > >> >This causes the first shell that is run (the parent shell) to run a >> >sub-shell, and the sub-shell in turn runs the DB-Access command in the >> >background and then exits immediately. The parent shell should >> >terminate immediately too, as the DB-Access process is not one of its >> >children. >> >> Doesn't work in NT. > >Well of course not - I was talking about a real operating system. > >-- >Yours, >Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> >Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN > "I don't suffer from insanity; I enjoy every minute of it!"