Or invoke the stored procedure through an External Action invoking a shell script that forks the SP in the background.

/John


Robert Shubert wrote:


There is no way to get around having a TAF wait for the DirectDBMS, but
you can call a TAF in a disposable way.


There might also be some options in SQL triggers, or using a different
language such as ASP to fire the SP.

Robert

-----Original Message-----
From: John McGowan [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 3:41 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: No wait for SQL


But then he still has a taf file running that is bounded by the query timeout configuration.

I've never done this before, but I'd probably focus on what capabilities

the DB allows for "forking" in a stored procedure.

/John

Stefan Gonick wrote:



Use the @URL command with waitforresult=false.

Stefan

At 03:32 PM 5/10/2004, you wrote:



Want to call a Sybase ASA 9 stored procedure but I don't want to wait





for a result.

I have a stored procedure that takes some time to execute. I want one





taf to call the stored procedure then jump to another taf that refreshes every 10 seconds, checks to see if the query is complete, other wise show's a please wait message.

My question is how to get Witango to release the call to the stored procedure without waiting for the procedure to finish and without killing the stored procedure.

Any suggestions?

Thanks...

Bryan Hughes
TFG-PIU
954-493-6565 x122




________________________________________________________________________


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


=====================================================
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com



________________________________________________________________________


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to