Archives of the TeradataForum

Message Posted: Tue, 12 Apr 2011 @ 13:18:56 GMT

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

Hi ,

I am trying to update a table.

     SOH_RTL_AMT (DECIMAL (11,2)= :SOH_RGLR_RTL_AMT (CHAR (19))+
     :SOH_PRML_RTL_AMT(CHAR (19)) + :SOH_CLRC_RTL_AMT(CHAR (19))

     SOH_RGLR_RTL_AMT=-0000000000000.0000
     SOH_PRML_RTL_AMT=+0000000000000.0000
     SOH_CLRC_RTL_AMT=+0000000000000.0000

SOH_RTL_AMT ,IDEALLY SOH_RTL_AMT SHOULD BE 0.00 .But the value which is coming is -3948.72.

Regards,

Madhu

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