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 Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023