Convert SQL Money format to a Floating Point AS/400 format
From Support
| | If you have a question or seek clarification, please call Technical Support. |
[edit]
Problem:
When reading an SQL database how do you convert an SQL Money format to an AS/400 Floating Point format?
[edit]
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.
