Convert SQL Money format to a Floating Point AS/400 format - Support

Convert SQL Money format to a Floating Point AS/400 format

From Support

Jump to: navigation, search
If you have a question or seek clarification, please call Technical Support.

Problem:

When reading an SQL database how do you convert an SQL Money format to an AS/400 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.

Personal tools