AND (inv.is_active = CASE WHEN $P!{dwhDBSchema}.dwh_boolean_to_int_fct($P{zInActiveIdea}) = 1 THEN inv.is_active ELSE 1 END)
Multiple markers at this line
- mismatched input ‘.’ expecting ‘THEN’
- mismatched input ‘dwh_boolean_to_int_fct’ expecting ‘END’
- missing EOF at ‘=’
This is part of the expression is giving me trouble at the period. This was written by another firm. Please help!
I tried removing the period and adding then to no avail
New contributor
HDW is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.