Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Wrong output
 
From:   madhu.priya

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