COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: jkabir on 06 Sep 2019 12:50:07 pm

Title: calling StoredProc from data manager
Post by: jkabir on 06 Sep 2019 12:50:07 pm
Hi M.F.
Thank you for your help last time.
This time could you help me with the calling SP from data manager. It is executed in sql server but when i am using SP node in data manager it is not executed. please find the pic attached. thanks
Title: Re: calling StoredProc from data manager
Post by: MFGF on 06 Sep 2019 02:33:06 pm
Hi M.F.
Thank you for your help last time.
This time could you help me with the calling SP from data manager. It is executed in sql server but when i am using SP node in data manager it is not executed. please find the pic attached. thanks

Hi,

I think you have misinterpreted what a Procedure Node is used for in Data Manager. It is there to allow you to define procedural code within a jobstream, not specifically to call a database stored procedure. Your easiest option is to use a SQL Node instead of a Procedure Node and call your stored procedure from within that. If you really do need to use Procedure node for reasons not mentioned in this post, you can also do this, but your SP call would need to be encapsulated within a sql() function.

Cheers!

MF.