Problem:

When reading an SQL database how do you convert an SQL Money format to DB2 Floating Point format?
 

Solution:

Since Money type in SQL = 8 you can use the MOVE operation to move it to a 19 length 4 decimal position Zone variable.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016