An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'

[kvchow]

Hi
I am getting this error when i page down the report
"An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'."UDA-SQL-0144 An arithmetic exception was detected.[IBM][CLI Driver][DB2/AIX64] SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007 UDA-CUR-0000 Unable to fetch the row

Any idea?

Thanks,
kvchow

[BigChris]

Are you trying to cast a datetime to a date, or a string to datetime or something like that? The error message suggests that you've got some duff data which isn't in the right format.