Stored procedures call

[IxiRancid]

Can I omit the "wait-time" when I run a Stored procedure? The thing is, my procedure goes on for 20mins, and thus I usually get timeout expired or the user falls asleep and does strange things.

I imagine that the application is waitting some out parameters from the server system or what? Can that be omitted?

 

[mike55]

Are you sure that your procedure should be running for 20 minutes, seems like a pretty long time?

Mike55.

 

[IxiRancid]

Its a DB2 stored procedure, but actually I figured something out. I got this project unfinished from a collague. He use ADODB conection and pass a SQL call statement. This often took more than 20mins and got Timeout Expired.
Now I used CWBX (IBM as400 dll) and just pass this call to the server. Dont know really how it connects to the server, but the thing is now faster. It runs approximately 3mins. Which of course is acceptable.

And the crowd went: "ooooh".