Thursday, September 13, 2012

Use in Expressions

You cannot use fixed-point decimal data with a nonzero scale factor in calculations with binary integer variables. If you must use the two types of data together, use the DECIMAL built-in function to convert the binary value to a scaled decimal value before attempting an arithmetic operation. For example:

DECLARE I FIXED BINARY, 
       SUM FIXED DECIMAL (10,2); 
 
SUM = SUM + DECIMAL (I); 

No comments:

Post a Comment

Comments