Sql Server procedures

[halima98]

Hello,

I am new to Cognos Data Manager and I would like to know if you can execute sql server procedures using Data Manager?  If so, how do I go about that process?

Thank you in advance.

[MFGF]

You could try coding a SQL node in a jobstream to call the SP (or use a SQL function in a derivation etc).  What kind of SP do you want to call - data retrieval or data modification?

MF.

[yepperstn]

... or you could use the SQL statement.  Per the Decision Stream help, the SQL statement executes the specified SQL statement on the specified database connection or alias.

The example provided in the on-line help:

SQL('Sales', 'DROP TABLE Temp') will drop the table named Temp from the Sales database.