I lost decimal precision when I retrieve data via SQL from the iSeries 400s. This occurs in some PC but not in all. For example: select amount from table, and amount is 123,12 the program received is 123,00.
This is not an ISERIES 400 SQL issue, but a client issue. You did not mention the name of the software you use for issuing the SQL but I'm sure the truncation is done on the client level and that is where you have to search for the solution.
MORE INFORMATION ON THIS TOPIC
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: tips, tutorials and more.
Dig Deeper on iSeries Access (Client Access)
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.