Skip to Content
0
Former Member
Jan 13, 2012 at 05:26 AM

DECODE SQL Function - Parsing error in Defining Objects in Universe Designe

367 Views

Hi,

I have created a class and an object in BO XI R3 Universe designer.

I am getting the parsing error while defining the object when using the custom SQL as

select decode(matteraction,null,decode(matterissue,null,'MATTER','ISSUE'),decode(matterissue,null,'TYPE IS ACTION',' ACTIONu2019)) as TYPE from wh_cf_cmsu

The object Type is "character", i have tried with Long Text, Number, Date as well and the same sql works fine by returning String values through TOAD.

Do we have any constrains in using DECODE in BO XI R3 or any other syntax please....

Please guide me in resolving this issue.

Thanks,

Karthik.