RE: Informix: Why does DECODE a json column in view does not work?

Posted in 2026

Emanuel Reisinger — source: IBM Community (ConnectedCommunity.org) Informix forum

Using a case instead of decode in the view works. DECODE(data_json, null, 0, 1) case when data_json is null then 0 else 1 end But why does decode not work? BR You are subscribed to "Informix" as paul.cdi@oninit.com. To change your subscriptions, go to http://community.ibm.com/community/user/preferences?section=Subscriptions. To unsubscribe from this community discussion, go to [link removed]