Error Retreiving results from server

[rajeevm]

Hi All,

I am trying to populate the Stage last table with the updated records what I have in the stage table but I am getting an error saying that "Error Retreiving results from server" and also I am getting "[IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003"

Can you please help me out what does this mean exactly?

Thanks for the help.

[shilpa79]

May be you have to check column by column and see if you have any sqltype or length not matching to any column on the target DB.

[narasimha]

Your input values are larger that your target fields can handle

Search my friend you will get a lot of results on similar issues

[rajeevm]

Hi


Thanks for your reply but each and every column is same and the length of the columns are also same.

I don't know why its coming like this I reran the job twice.

Thanks for the help,

[shilpa79]

Why donot you delete the input stage and again import the metadata and see, if it works
validate the data may be in char field its passing some numeric values.......

[rajeevm]

Thanks Shilpa,

I reloaded the meta data and I changed the columns in this which were different in SQL select may be that is why I was getting that one .

Thanks for your help,

[narasimha]

Did that solve your problem?

Here is a reference for Call Level Interface (CLI) messages, for further use.

http://publib.boulder.ibm.com/infocente ... climsg.htm

[kab123]

you are trying to load a value which is out of its range.
ex: If target column's datatype is Decimal(2,2) and you send a value 20.300 you will get this problem. try to truncate the data and load 20.30 and see if that problem exists.