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
sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
IF ISNULL(DSLink.xxxx) THEN 'How you want it look in your sequential file' ELSE DSLink.xxxx.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: