Archives of the TeradataForum

Message Posted: Mon, 18 Oct 2010 @ 13:22:22 GMT

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

Hi All,

As per the Teradata document there are two types of User Defined Datatypes 1.Distinct 2.Structured

Here I created is a distinct userdefined datatype CREATE TYPE BOOLEAN as BYTEINT FINAL;

I was able to cast the datatype of column and fixed in Procedure,But am still receiving the same error

" Provider does not support conversion from BYTEINT to System.Boolean"

This means creating a Userdefined Datatype doesn't resolve the problem, Even if I create a UDT the query is referring UDT as BYTEINT only not as BOOLEAN.

Regards

Asish

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