DSXchange

Hi
I tryto load data oracle DB

Source Txt file

here is how data looks like with column names being A B C D and E
and datatypes being decimal decimal decimal char char respectively and dataelements defined as number(8,2) ,number 8,2 ,number8,2 ,date.tag 10,date.tag 10
and nulls allowed for last column
A B C D E
4.8 1985-01-01 100871 3.2 1985-12-31
58 1985-01-01 100890 46.4

with direct mapping in the transformer I get the following warning

exercise4..Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO PRICES(PRODID, STDPRICE, MINPRICE, STARTDATE, ENDDATE) VALUES (?,?,?,?,?)
SQLSTATE=22005, DBMS.CODE=0
[DataStage][SQL Client]Non-numeric data was found where numeric required

PRODID = 4.8
STDPRICE = 1985-01-01
MINPRICE = 100871
STARTDATE = "3.2"
ENDDATE = "1985-12-31"

How should i fix this ?
Please explain


Thanks

You are trying to insert non-numeric value to a numeric filed. I suspect your mapping is not correct, see what you have passed as values for STDPRICE and STARTDATE

PRODID - number(8,2)
STDPRICE - number(8,2)
MINPRICE - number(8,2)
STARTDATE - date.tag (10)
ENDDATE - date.tag (10)
==================
PRODID = 4.8
STDPRICE = 1985-01-01
MINPRICE = 100871
STARTDATE = "3.2"
ENDDATE = "1985-12-31"

Oh yeah ....did not notice that ...

That takes care of that .

Thanks George