Decode Vs CASE in IQD Files

[Prasad678]

Hi,
I have an IMR which internally uses Decode function of Oracle.
When I save that as IQD, instead of Decode, CASE is used.

I tried changing all the INI settings like,
[Query Options] parameter, Case_To_Decode=T etc.. but still the probs exists.

IMR is fine, but IQD is not. Does anyone have a solution for this??




Prasad
RPrasad1@Chn.Cognizant.com

 

[CognosProfessional]

You need these 2 settings..

In the impromptu.ini file,
add the following under the [Query Options] section:
Use automatic Oracle Decode=0

In the cogdmor.ini file, change
Case_To_Decode=T to Case_To_Decode=F
under the appropriate version of the Oracle database.



CP