'ERROR [22005] [IBM] CLI0112E Error in assignment. SQLSTATE=22005' when updating data grid with a decimal character (4374330)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

'ERROR [22005] [IBM] CLI0112E Error in assignment. SQLSTATE=22005' when updating data grid with a decimal character
Description

When updating data in the data grid, and the decimal separator of the Window environment is a ',' as opposed to a '.', the following error appears:

'ERROR [22005] [IBM] CLI0112E Error in assignment. SQLSTATE=22005'
Cause

There is an issue where any non-standard decimal separator character other than '.' causes this issue.
Resolution

WORKAROUND:
Please update the data using a SQL statement, as opposed to manually editing the data grid

STATUS:
Waiting for fix in a future release of Toad Data Point
Defect ID

QAT-19216

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title