COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: Srik on 28 Oct 2005 03:48:36 PM

Title: Stored Procedures
Post by: Srik on 28 Oct 2005 03:48:36 PM
Can any help me How to identify stored Procedures in Decision strean catalog.

Thanks in advance
Kanth
Title: Re: Stored Procedures
Post by: CoginAustin on 28 Oct 2005 06:28:57 PM
Identify them?
Title: Re: Stored Procedures
Post by: Srik on 30 Oct 2005 04:25:44 PM
I mean to say were can i implementÃ,  Stored Procedures(write and Modify) in Decision Stream stages ?
Title: Re: Stored Procedures
Post by: MFGF on 31 Oct 2005 02:36:13 AM
Hi,

DecisionStream does not create or modify stored procedures as part of it's normal processing.  You do have the ability to call stored procedures which have already been defined in the database, and these can be called from a derivation, output filter, UDF, jobstream procedure node, jobstream condition node or variable definition (using a SQL function), or from a SQL node of a jobstream.

Best regards,

MF.