Hi,
I am having some decimal columns in my Source sequential file.
Whenever I get junk data for these(which is not decimal) I want to default them to NULLS.Please let us know if this can be done??
Can we set the default to null!!
Moderators: chulett, rschirm, roy
nynali - it would be better to post in the appropriate forum, but I'm sure a moderator will find this thread and relocate it.
You can set the the default value by right-mouse clicking on the colum and then "edit row" to get to the details.
You can set the the default value by right-mouse clicking on the colum and then "edit row" to get to the details.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Well, we still have no idea whether this is a server job question or a parallel job question. Therefore we still have no way to answer it, apart from "yes", or "maybe (it depends where)".
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.
Yes this is possible but process may differ from server job to Parallel job.
To set the value to null you have @NULL in server jobs and setnull() function in parallel job. Before assigning the null value you have to check the incoming field value is junk. There are different function available to check the format of the incoming data.
To set the value to null you have @NULL in server jobs and setnull() function in parallel job. Before assigning the null value you have to check the incoming field value is junk. There are different function available to check the format of the incoming data.