Hi ,
I am using a change capture stage and the before and after datasets have nullable varchar2 columns..My change capture stage is not working fine .. I am not sure whether the Change capture stage would compare the Null in varchar2 columns ... How do i check whether the change capture stage is treating records with Null in before and after datasets as copy records not as ipdate records
Nullable check in change capture
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
Nullable check in change capture
Regards
Ragu
Ragu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Since NULL can not be compared to anything (even another NULL) I believe that what you are trying to do is not valid. Handle the nulls by converting to in-band null or dropping those rows upstream of the Change Capture 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.