DSXchange

When we are writing data into sequential file

Do we need to check all columns for Null value?

IF ISNULL(DSLink.xxxx) THEN '' ELSE DSLink.xxxx

When i view the sequential data i am seeing NULL in some column value?


Thanks in advance

Probably , your peers might have used the Null field value property to populate "NULL" for null values.

Short answer is "no". But you DO need to specify how NULL will be represented in the text file. This can be done with a global property on the Format tab or differently for individual columns.

sequential file-->Format-->Field defaults-->Null field value = ''

o/p:

Still i am ending up with NULL in some column values?

Did i miss any thing?

How we can check null for individual columns

How would you want the in coming null to look in the sequential file. Based on your need change the transformation to reflect for individual columns or at a global level

IF ISNULL(DSLink.xxxx) THEN 'How you want it look in your sequential file' ELSE DSLink.xxxx.

"How you want it look in your sequential file " what the best practice?

What does it mean by at global level? How should i set it?


Thanks

What I mean by "at global level" is "for all fields in the record structure". This is set on the Format tab.