Defined type name error

Database
Enthusiast

Defined type name error

Hi,

I get this type of error for below statement:

SELECT COUNT (DISTINCT Userid) 
FROM PDB.View
WHERE
src_id IN (123)
AND Src_Cd = 'AB'
AND PGM = 'LN';

Error:

SELECT Failed. [3706] 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,

Nik

1 REPLY
Enthusiast

Re: Defined type name error

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.