Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
jerome_rajan
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Post
by jerome_rajan »
I am trying to run the grep command in an external filter stage.
But I get an error saying
Field X is null but no null export handling is defined
Didn't know we had to handle nulls here too. How do I do this?
Jerome
Data Integration Consultant at AWS
Connect With Me On
LinkedIn
Life is really simple, but we insist on making it complicated.
-
rameshrr3
- Premium Member
- Posts: 609
- Joined: Mon May 10, 2004 3:32 am
- Location: BRENTWOOD, TN
Post
by rameshrr3 »
In Format Tab Set NullField Value = ''
-
jerome_rajan
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Post
by jerome_rajan »
Are you sure that an external filter stage has a format tab? Because I don't see it. Guess you confused it with a sequential file stage
Jerome
Data Integration Consultant at AWS
Connect With Me On
LinkedIn
Life is really simple, but we insist on making it complicated.
-
rameshrr3
- Premium Member
- Posts: 609
- Joined: Mon May 10, 2004 3:32 am
- Location: BRENTWOOD, TN
Post
by rameshrr3 »
Can you edit row metadata ? There you can set null field value
-
jerome_rajan
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Post
by jerome_rajan »
rameshrr3 wrote:Can you edit row metadata ? There you can set null field value
No
Jerome
Data Integration Consultant at AWS
Connect With Me On
LinkedIn
Life is really simple, but we insist on making it complicated.