Hi all,
I had unusual behaviour when I used NULLTOZERO against the composite primary key, obiviously primary key field will not be NULL. But unfortunately I tested this function, it's returning only zero value, its not taking the value in that field.
for example
below are the four fields, in that Inlink.field1 Inlink.field2 are primary key fields
Inlink.field1 Inlink.field2 Inlink.field3 Inlink.field4
25488 0 like fruit
25488 2543 nike veg
expected result is
Outlink.field1 Outlink.field2 Outlink.field3 Outlink.field4
25488 0 like fruit
25488 2543 nike veg
But the result obtained is
Outlink.field1 Outlink.field2 Outlink.field3 Outlink.field4
25488 0 like fruit
when I removed that Nulltozero on Inlink.field2 I am getting two records in the oracle database
Outlink.field1 Outlink.field2 Outlink.field3 Outlink.field4
25488 0 like fruit
25488 2543 nike veg
I want to know this behaviour of NULLTOZERO against the primary key has anyone faced this type of problem?
behaviour of NULLTOZERO against primarykey field
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Which NULLTOZERO is this?
The supplied Transform is called NullToZero (and it's case sensitive).
If you have your own NULLTOZERO routine/transform, I'd suggest you test it more thoroughly.
The supplied Transform is called NullToZero (and it's case sensitive).
If you have your own NULLTOZERO routine/transform, I'd suggest you test it more thoroughly.
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Transform is entirely agnostic about whether or not the value on which it is operating is a primary key or not. If the argument is null, then 0 is output. If the argument is not null, then the argument is output. End of story.
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.