Problem in Reading DECIMAL fields
Posted: Fri Jun 27, 2008 4:13 pm
Hi Everybody ,
Thank you all for solving many of my problems.
Now i am facing another problem .
My job design
Seq ----------->>> Trans ----------->> oracle
I have some decimal fields in the input sequential field .The format i specified
for decimal fields is ---- packed=no(overpunch) signposition ( trailing ).
I am able to read data correctly through view data.But ,in the input file i am
getting data differently its getting rejected.
Suppose field F1 DECIMAL(4,0 ) is there ....
If data in input field is 1234 ------->> view data o/p 1234
data in input field is 34 --------->> data getting rejected .Because i am getting 2 spaces in the input data .
I want this 34 to be loaded into the target .
Could anybody help how to load it into the target oracle stage without getting rejected .??
Thank you all advance
Thank you all for solving many of my problems.
Now i am facing another problem .
My job design
Seq ----------->>> Trans ----------->> oracle
I have some decimal fields in the input sequential field .The format i specified
for decimal fields is ---- packed=no(overpunch) signposition ( trailing ).
I am able to read data correctly through view data.But ,in the input file i am
getting data differently its getting rejected.
Suppose field F1 DECIMAL(4,0 ) is there ....
If data in input field is 1234 ------->> view data o/p 1234
data in input field is 34 --------->> data getting rejected .Because i am getting 2 spaces in the input data .
I want this 34 to be loaded into the target .
Could anybody help how to load it into the target oracle stage without getting rejected .??
Thank you all advance