Re: Hi

Well, in a way you can. It's called a background job:

sqlplus user/pass @test &
sqlplus user/pass @test1 &

The '&' will submit the given task as a background job, thus returning control to the calling shell allowing yet another statement to be processed. If you want the first job to run in the background and have the second job run 'live', simply remove the second '&':

sqlplus user/pass @test &
sqlplus user/pass @test1

test.sql will be executed in the background whilst test1.sql will run in the foreground.

David Fitzjarrell

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<zGwN9.8566$jM5.24124_at_newsfeeds.bigpond.com>...
> I think you've missed his point. He wants to run a shell script which runs
> multiple SQL scripts, and have each SQL script run asynchronously. As
> SQL1.sql runs, so the shell script starts running SQL2.sql, without waiting
> for the first one to finish and return.
>
> Can you script something asynchronously?
>
> God knows. But that's what he's after, I think.
>
> Regards
> HJR
>
>
> "Ban Spam" <ban-spam_at_operamail.com> wrote in message
> news:Xns92ECB2C273F85SunnySD_at_68.6.19.6...
> > "Oradba Linux" <oradba_linux_at_attbi.com> wrote in
> > news:pan.2002.12.22.23.57.29.503034_at_attbi.com:
> >
> > > Yeah you are right thats why i am posting to newsgroup .
> > > I did not want to know how to call sql script from a korn shell script
> > > . But i want to know how to run another SQL statement continuously (
> > > possibly another shell script ) while this sql script is running .
> > >
> >
> > So what's stopping you from opening another "Window" on your Linux box
> > and launching the 2nd script?
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > HAND!
Received on Mon Dec 23 2002 - 11:43:41 CST