|
|
Archives of the TeradataForum
Message Posted: Thu, 13 Jul 2007 @ 00:49:02 GMT
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
| |