Null values for FMT AND EBCDIC

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
devsonali
Premium Member
Premium Member
Posts: 155
Joined: Sun Mar 18, 2007 2:31 pm

Null values for FMT AND EBCDIC

Post 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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply