SQLFetch: Error retrieving results from server

lakshya · Post by **lakshya** » Tue Apr 05, 2005 7:46 am

Hi all,

I am running a job with update statements and am getting the following warnings.I have set the limit of warnings to 50 and hence the job is getting aborted.Any suggestions?

SQLFetch: Error retrieving results from server

[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005

Thanks in advance

ketfos · Post by **ketfos** » Tue Apr 05, 2005 10:31 am

Hi,
What are the datatypes in the target table which is being updated?
Are you trying to assign a variable of the type BLOB to the field?

Ketfos

lakshya · Post by **lakshya** » Tue Apr 05, 2005 9:15 pm

Hi,

There was a data type mismatch from the source to the target field and I had overlooked it.I got it right.

Thanks