COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: ari_meta on 22 Sep 2010 09:01:56 PM

Title: User Defined Function
Post by: ari_meta on 22 Sep 2010 09:01:56 PM
We have a user defined function in DB2. I can execute that function on the database. I can import that function in to the Framework Manger. I am unable to execute that function in the Framework Manager.

I am getting below error codes –

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "prepare".
[IBM][CLI Driver][DB2/LINUXX8664] SQL0440N No authorized routine named "INITCAP" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884






Any help will be appreciated.


Thanks

Ari