C8.2 - Using DB2 function timestampdiff in FM

Stephane Lambert · 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,

blom0344 · 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 ..

BSP Software	Resources	About Us
MetaManager	BSP Software Training	BSP Software
Integrated Control Suite	YouTube Channel	Micro Strategies Inc
Security Migration		IBM Cognos
Integrated Management Suite

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