Page 1 of 1

Null values for FMT AND EBCDIC

Posted: Thu Apr 10, 2008 1:12 pm
by devsonali
Hi Everybody

I have a datastage job that is using EBCDIC(FMT(COLUMN_NAME))
it looks like whenever there is a null value for the column (column_name),the job aborts.
This is the error that shows up


DataStage Job 1307 Phantom 7596

Program "JOB.1752826515.DT.1437551087.TRANS2": Line 100, Improper data type.
Attempting to Cleanup after ABORT raised in stage BCEvt131.BAT.map2

DataStage Phantom Aborting with @ABORT.CODE = 3


I just wanted to make sure if that causes the error (EBCDIC(FMT(NULL VALUE)) ?

Please give me your views on the same.
Thanks

Posted: Thu Apr 10, 2008 2:48 pm
by chulett
To 'make sure', code around the nulls - only call that derivation when the source field is not null. Then see if your error goes away.