Sequence calling stored procedure is never ending

major · Post by **major** » Thu May 08, 2008 3:09 am

Hi ,

I am using an ODBC stage to call a store procedure with one paramater , whenever i am running the job it is not coming to finished state , it is in running state only till i abort it , but when i run procedure separately it is going fine . Can some one please tell me what cauld be reason for that.
Thanks in advance

kcbland · Post by **kcbland** » Thu May 08, 2008 7:24 am

Does your procedure return any rows to DataStage?

major · Post by **major** » Thu May 08, 2008 7:29 am

kcbland wrote:Does your procedure return any rows to DataStage? ...

No , it wont return any rows to datastage , the main objective is to run the procedure through datastage ,so that some tables are populated which are used in next level jobs

kcbland · Post by **kcbland** » Thu May 08, 2008 7:51 am

How are you calling the SP? In before/after-SQL tab or as the SQL query? Has this job previously worked and is it now failing?