Hi Dsxians,
I am facing with a warning in datastage job and issue of insering decimal values into oracle DB.
I have a multiplication of two string values from source file after converting from string to decimal 28,12 and doing a
multiplication and storing in a target column of decimal 28,12.
SVFirstval= 0000000784752326.540000000000
SVsecondval= 0000000000011100.000000000000
SVCal= 0008710750824594.000000000000(SVFirstval*SVsecondval)
I am getting the below warning for the calculated values in stage variable and while inserting target column,
job aborted with invalid integer as error.
Warning:
APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal.
Database column is of size is of decimal 28,12.Could you please help me in resolving this.
Thanks
snt_ds
Unable to Insert decimal value to oracle DB
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Can you have a seq file output in addition to the DB stage and see what is the value it is trying to insert for the calculated field?
Also, check the data type of the stage variable? You may want to define it as a decimal with proper scale/precision.
Also, check the data type of the stage variable? You may want to define it as a decimal with proper scale/precision.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: