DSXchange

I have a simple parallel job with a DB2 connector stage and a sequential file stage. I want to bring in a schema file in the sequential stage so I can override some things as it is exported.

I have a field that is nullable and is defined as DECIMAL[9,0] on the source. If this field is nulls I want it to export all zeroes for a length of 9.

I can't seem to get anthing to work! I've tried at least a zillion combinations... feels like it anyways!

Here are just a few...

FIELD1:nullable DECIMAL[9,0]{null_field=' ',padchar='0', default='000000000'};

FIELD1: nullable dfloat {null_field=' ', padchar='0', text, out_format='%9.0f',width=9};

FIELD1:DECIMAL[9,0]{padchar='0', text, fix_zero, zoned, unsigned};

FIELD1:nullable STRING[11]{default='000000000', null_field=' '};


Any help would be greatfully appreciated!

How about null_field = '000000000' ?

FIELD1:nullable DECIMAL[9,0]{null_field='000000000',padchar='0'};

Tried this... no luck.