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

[Former Member]

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.

[Former Member]

Hi,

1.At back end check the data type for matteraction column and define it accordingly in object definition.

2. Try to break your select clause definition into smaller parts and check it where the exact issue is as below

i.select decode(matterissue,null,'TYPE IS ACTION',' ACTIONu2019) ............

ii.select decode(matteraction,null,decode(matterissue,null,'MATTER','ISSUE') ..........

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

[former_member184995]

Moving to appropriate forum.