Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Error 5355 on CAST
 
From:   Sapra, Kapil Dev

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