I am running this code in the ETL Filter of Source Qualifier of Informatica. It's like a filter while importing data.
UNIT is one of the columns in my table.
The line of code is
SUBSTR(TO_CHAR(UNIT),5,1) = '0'.
We dont specify Where in the Source Qualifier as it assumes it.
But I get a error messge saying that
SQL0204 - TO_CHAR in *LIBL type *N not found.].
Is there any other way I can achieve this filter .