I am using SUBSTR in a WHERE clause in an SQL DB2.statement.
substr(ldate,1,4) = substr(mdate,1,4)
I get the following error.
"SELECT - 0 row(s), 0.000 secs] [Error Code: -440, SQL State: 42884] DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=SUBSTR;FUNCTION, DRIVER=3.57.82"
Is anyone familar with this?
Thanks in advance!