Skip to Content
avatar image
Former Member

DecodeFunction error in 4.2 IDT

Hi Guys,

I am trying to build a Multi source IDT universe, in which i have a object that has the necessity of using DECODE function. When i make use of the decode function and validate am getting the below error message "Function 'DECODE' is unknown". Can you guys let me know is there any restrictions in using the decode function in Multi source IST universe.

Complete Error Message : Error: [Data Federator Driver] [Server] Function 'DECODE' is unknown Cause of Error Function 'DECODE' is unknown

Thank You

Appu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 08 at 06:44 PM

    The Multisource syntax does not support DECODE. You'll have to rewrite it as a CASE WHEN.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08 at 07:22 PM

    Hi Peter,

    Thank you for the response.

    I can replace Decode function by Case when, but i have a database function/package that needs to be called inside in the Object.

    The package/function that i call will calculate the working days based on our business logic.

    Cant we make use of any of the database related functions inside IDT, Please clarify?

    Thanks,

    Appu

    Add comment
    10|10000 characters needed characters exceeded