Tag: DB2 Stage
DataStage : DB2 Stage : Failure during execution of operator logic
by Frederick Tybalt on Jun.30, 2017, under Error and Issues
Error Details :
Failure during execution of operator logic.
Output 0 produced 0 records.
APT_Decimal::assignFromString: invalid format for the source string. Expecting trailing NUL, space, or tab character(s) got ‘E’
Resolution:
One of the column which has the SQL type Decimal has the value “5E+7” which was not able convert to Decimal value. To eliminate this error read the column as String
This could happen when the decimal field is computed. To revert back to decimal field use explicit cast function
CAST(CAST(DISBURSED_AMOUNT AS FLOAT) AS DECIMAL(31,2))
Platform :
DataStage 11.5 running on linux
DASHDB 10.5 running on linux