Delete comment from: Javarevisited

Anonymous said...

select
dd.DELIVERY_ID,
dd.DELIVERY_NAME,
dd.DELIVERY_STATUS_ID,
dd.PUBLIC_FLAG,
case
when dd.DELIVERY_STATUS_ID = '2' and dd.PUBLIC_FLAG = '1' Then 'Y'
Else 'N'
END as Is_it_Deliverable?
from data_governance.DC_DELIVERABLE as dd
where dd.DELIVERABLE_NAME ilike '%ix_man.DIM_PORT_TO_CITY%';

facing an error >>>code 0 sql state 10940
In case statement >>> (dd.DELIVERY_STATUS_ID = '2' and dd.PUBLIC_FLAG = '1')

Jun 7, 2022, 1:50:44 AM

Posted to How to fix java.sql.SQLException: Invalid column index? Example