Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Thu, 13 Jul 2007 @ 00:49:02 GMT





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 




Subj:   Re: 3706 Syntax error: Data Type does not match a Defined Type name
 
From:   Stegelmann, Rolf



  I don't have time to test all this but I thought the scenario above could actually occur. Your error message does strike me as very different from the usual in such cases vague "incorrect syntax" messages (like "expected something between A and B").  


In 6.1 and beyond with the addition User Defined Types the expression length(..) could be a function of a constructor method of a UDT. Problem is that it did not match a built in function or UDF or UDM. So it guessed at that it was a nonexistent name of a constructor method. It really can't tell which it is at that point.


Rolf





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 09 Nov 2008