If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

decode error

Started by dcompain, 03 Oct 2007 04:03:59 PM

Previous topic - Next topic

dcompain

I created query subjects in FM, and there are some decode functions in the query subjects creating additional columns in the query.  I published to reportnet, and when I try to use one of the columns that contains the decode function, at run-time, I'm getting the following message:

"QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-228'.

UDA-SQL-0219 The function "decode" is not available as an external, database, or built-in function."

I'm running on Oracle DB 10g Rollup Processing in FM is set to "Database."  Any Thoughts?  Please help.

zaith

Try use "case when" instead of decode.