Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: Stephane Lambert on 28 May 2009 08:53:30 AM

Title: C8.2 - Using DB2 function timestampdiff in FM
Post by: Stephane Lambert on 28 May 2009 08:53:30 AM
Hi,

I'm trying to use the timestampdiff function (DB2) but it seems that FM is not recognizing it.

Any clue ?

Regards,
Title: Re: C8.2 - Using DB2 function timestampdiff in FM
Post by: blom0344 on 28 May 2009 03:01:41 PM
Yes, in an SQL object you will need to SQL-type from Cognos to Native (through options)
This bypasses the UDA and is directly fed to  DB2 ..
Text only | Text with Images