Anybody noticed that with the database update task within EventStudio, the options to specify how stored procedure parameter values are set/handled appear disabled?
The stored proc parameters can be seen (they are displayed in the task details page), but the properties to define their values & behaviour are 'greyed out'.Ã, ???
Any help or ideas would be appreciated..
Regards
Mike
Cognos Support helped out with this one...
After importing the stored procedure into the FM model, and marking it as a 'data modification' procedure, you need to set values for the stored proc's parameters - the values can be either static or dynamic, and in the latter case it makes sense to put a "prompt" as the value.
eg for the @param1 parameter in my stored procedure I have set its value (in FM) to ?param1_prompt?
This will enable the parameters to be configured within Event Studio.
Hi All,
Have you actually had success running an update stored proc through Event Studio?
Love to hear that you have ... mine does not seem to work!
cheers,
DW
It's only a simple SP, but yes it works fine.
What problems are you getting?
MF.