Problem solve Get help with specific problems with your technologies, process and projects.

Lost decimal precision

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.


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.

This was last published in January 2002

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.