I get this type of error for below statement:
SELECT COUNT (DISTINCT Userid) FROM PDB.ViewWHERE src_id IN (123) AND Src_Cd = 'AB' AND PGM = 'LN';
SELECT Failed.  Syntax error: Data Type 'P' does not match a defined type name.
It does not make any sense to me. This error is not constant as well. It shows up sometimes only.
Can someone please help?
Thanks in advance,
I think I got the error resolved.
It went away after I restarted the TD SQLA. I still don't know why it happened though.