Archives of the TeradataForum

Message Posted: Wed, 21 Jul 2010 @ 14:26:21 GMT

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

Hi,

Just replace second view (without CAST in Srvc_Type_Cd column) :

From:

     cast(Srvc_Type_Uid as INTEGER) as Srvc_Type_Uid , cast(Srvc_Type_Cd as
     CHAR(64)) as Srvc_Type_Cd, cast(Srvc_Type_Nm as VARCHAR(100)) as
     Srvc_Type_Nm

TO:

     cast(Srvc_Type_Uid as INTEGER) as Srvc_Type_Uid , Srvc_Type_Cd as
     Srvc_Type_Cd , cast(Srvc_Type_Nm as VARCHAR(100)) as Srvc_Type_Nm

I believe, It will work fine. Thanks.

Best Regards,

Kapil Dev Sapra

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