Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Jun 2006 @ 09:57:29 GMT


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


Subj:   Re: Fast export data file problem
 
From:   Raghu_Senapathi

Hi Tanu,

Below one is not working...

Is it like this..

     (CAST (a as char(10))
     ||'|'||  (CAST (CAST (b as varchar(60))) AS CHAR(70))

see my below script..I want to change only DBS_Agmt_Hist_Amt column...

     sel
     (COALESCE(Trim(Cast(Account_Num                    as Char(060))),
     ''))||'|'
     ||(COALESCE(Trim(Cast(Account_Modifier_Num          as Char(060))),
     ''))||'|'
     ||(COALESCE(Trim(Cast(Time_Period_Cd                as Char(060))),
     ''))||'|'
     ||(COALESCE(Trim(Cast(DBS_Agmt_Hist_Start_Dt       AS DATE FORMAT
     'YYYY-MM-DD')), ''))||'|'
     ||(COALESCE(Trim(Cast(DBS_Agmt_Summary_Type_Cd      as Char(060))),
     ''))||'|'
     ||(COALESCE(Trim(Cast(Currency_Cd                   as Char(060))),
     ''))||'|'
     ||(COALESCE(Trim(Cast(DBS_Agmt_Hist_Amt             as Char(060))),
     ''))||'|'
     ||(COALESCE(Trim(Cast(DBS_Agmt_Hist_End_Dt         AS DATE FORMAT
     'YYYY-MM-DD')), ''))||'|'
     ||(COALESCE(Trim(Cast(Product_Id                    as Char(060))),
     ''))||'|'
     ||(COALESCE(Trim(Cast(DBS_Source_System_Id          as Char(060))),
     ''))||'|'
     ||(COALESCE(Trim(Cast(PARTY_HOST_NUM_LEGAL_ENTITY   as Char(060))), ''))
     (char(500))
     from DT_MART_CPMS_IN.CPMS_NIX_IBALCE;

Thanks & Regards,

Raghu



     
  <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