DSXchange

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.

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.

Your input values are larger that your target fields can handle

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

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,

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.......

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,

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

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.