All Forums Database
Nikhil_Teradata 24 posts Joined 10/13
06 Jul 2016
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

--Nik

"Learn, Learn, Learn and your life would never be boring"

Nikhil_Teradata 24 posts Joined 10/13
06 Jul 2016

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.
 

--Nik

"Learn, Learn, Learn and your life would never be boring"

You must sign in to leave a comment.