Unable to Insert decimal value to oracle DB
Posted: Fri Jan 16, 2009 10:31 am
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
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