Hi
how to handle nulls in source level
nulls
Moderators: chulett, rschirm, roy
If yuo are using oracle enterprise stage, you can use NVL fucntion to handle null.
If you are using sequential stage to read ascii file you can handle them at column level . edit the column and provide NULL value and that will be replaced if found any null.
If you are using sequential stage to read ascii file you can handle them at column level . edit the column and provide NULL value and that will be replaced if found any null.
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your question is too broad. What kind of source?
Technically sequential files don't have data types and therefore can't have nulls. But we often pretend that they have data types, and therefore must specify how null is represented. This is typically managed through the Null Field Value property.
Technically sequential files don't have data types and therefore can't have nulls. But we often pretend that they have data types, and therefore must specify how null is represented. This is typically managed through the Null Field Value property.
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.