Hi,
Iam having trouble converting the null values to not null. Can you please guide how to convert the nullable values to not null using the transformer stage or any db2 query ( i used nvl and coalescequery it is not working )
Iam getting the values from the database which are having null values and i need to do transformation and updated them into another table there those fields are not null.
how to convert nullable to not null values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 89
- Joined: Sat Jul 24, 2010 11:33 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please be more specific about what you mean by "it is not working" and what - precisely - you want to do with inbound NULL values.
It should be straightforward once you have decided on how NULL is to be represented in the not null column - simply convert any inbound ("out of band") null into that representation ("in band null"). Use NullToValue() function in a Transformer stage.
It should be straightforward once you have decided on how NULL is to be represented in the not null column - simply convert any inbound ("out of band") null into that representation ("in band null"). Use NullToValue() function in a Transformer stage.
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.
-
- Participant
- Posts: 31
- Joined: Thu Jul 05, 2007 11:57 pm
- Location: India
- Contact:
Re: how to convert nullable to not null values
We are having NullToValue function in transformer stage.Make use of this.developeretl wrote:Hi,
Iam having trouble converting the null values to not null. Can you please guide how to convert the nullable values to not null using the transformer stage or any db2 query ( i used nvl and coalescequery it is not working )
Iam getting the values from the database which are having null values and i need to do transformation and updated them into another table there those fields are not null.
Thanks
Sultan
Sultan
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: