Skip to Content
0

DecodeFunction error in 4.2 IDT

Feb 08 at 06:20 PM

34

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Joe Peters Feb 08 at 06:44 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 08 at 07:22 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded