DSXchange

Hi folks,
One of the developers here is loading a UDB column defined as decimal(7,2) and the delimited file he is using as input has the numeric fields that are positive preceded with a "+" sign for that column. Would datstage throw out the following error for the "+" sign or is there something else we should be looking for.
SQLSTATE=22005, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]Invalid character value. Error in parameter 25.

Thanks -- John

That might be it. Remove the + sign using the CONVERT() function and then try. If the error goes away then that was it, else more investigation is needed.