Search found 3 matches

by harryn
Tue Feb 27, 2007 10:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to keep a record with some null fields
Replies: 5
Views: 2240

Yes, I set NullFieldValue to spaces. But if I don't set this property. The records are even dropped at the Column Import stage. By setting this property I got them thru the next Transformer stage... The field in question is a Date type field. At the Transformer's mapping, I tried to manipulate the o...
by harryn
Tue Feb 27, 2007 12:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to keep a record with some null fields
Replies: 5
Views: 2240

How to keep a record with some null fields

One of my input data field is sometimes blank. By setting a [null field value] property I managed to get it through the Column Import stage but when it hit the next Transformer stage, the whole record is dropped just because of this null field. And I do want to keep this record. This problem sounds ...
by harryn
Tue Feb 27, 2007 12:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Covert comma separated decimal field to DataStage decimal
Replies: 5
Views: 8073

Is this the only way to handle this situation? I would have thought that comma in decimal figure is basic stuff and should be handled either implicitly or explicitly with format string?