Archives of the TeradataForum

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

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

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>>