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!
External Schema File
Moderators: chulett, rschirm, roy
External Schema File
Argus Health
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: