Column Import stage, defaulting decimal to null

[dsguyok]

Hi, I am using a Column Import stage to read EBCDIC data. The stage reads in one big column and produces many smaller columns from it.

One of those is a packed decimal field which contains EBCDIC spaces (ie 40404040).

So I want to use the "default" property on that field to default to null on error (ie when the stage sees those spaces).

Is there a way to default to null for this field?

Defaulting to zero works because it is a decimal field. But so far \x00 and \0 don't work because Datastage interprets those as characters which violate the type checking phase I guess. Thanks.