problem with string to decimal conversion
Posted: Mon Sep 24, 2007 12:47 pm
hi,
i have two sequence of jobs, one writing data from seq file to dataset and other is to load the data from the dataset(o/p from the first job) into an oracle table.
input:-seq file, 5 columns. for "qty" column, datatype of varchar, no fixed length and nullable. it has values like 30,4,120,1340, ...
i am trying to do a transform from varchar, no lenght and nullable TO decimal, length 5 scale 3 and nullable.
i tried stringToDecimal, but i am getting the o/p as below
inp
qty
4
30
130
60
1450
o/p
04.000
30.000
00.000
60.000
00.000
and i am getting the following warning.
Conversion error calling conversion routine decimal_from_string data may have been lost.
all i need is to get the same numbers as in the input but i need them in number format.
can anyone help me out.
thanks
i have two sequence of jobs, one writing data from seq file to dataset and other is to load the data from the dataset(o/p from the first job) into an oracle table.
input:-seq file, 5 columns. for "qty" column, datatype of varchar, no fixed length and nullable. it has values like 30,4,120,1340, ...
i am trying to do a transform from varchar, no lenght and nullable TO decimal, length 5 scale 3 and nullable.
i tried stringToDecimal, but i am getting the o/p as below
inp
qty
4
30
130
60
1450
o/p
04.000
30.000
00.000
60.000
00.000
and i am getting the following warning.
Conversion error calling conversion routine decimal_from_string data may have been lost.
all i need is to get the same numbers as in the input but i need them in number format.
can anyone help me out.
thanks