sequential file

[dsuser91]

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

[major]

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

[ray.wurlod]

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.

[dsuser91]

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

[narasimha]

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.

[dsuser91]

"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

[ray.wurlod]

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