I have requirement like in the below query.
SELECT MAX(ACDFCPNN) FROM TE.UTE01011_ACFTDEFCT
WHERE ACFTABB = WS_ACFTABB
I tried to run this query in QMF when the value passed in WS_ACFTABB is not available in table then the query is returning Null value as '-' .
Now then I have rquirement to move Zero to the host variable WS_ACDFCPNN when the query returns null value ie '-'.
Can somebody assist that how to handle this.