For varchar null handling can i give NullToZero in transformer. Will it take implicitly zero as string or i have to give NullToValue(column,'0').
Thanks in advance.
Null to value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If the data type is string it's more efficient to provide a quoted value, thereby avoiding the overhead of the implicit conversion (which nevertheless requires some processing).
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.