Checking for Integer Datatype
Moderators: chulett, rschirm, roy
Checking for Integer Datatype
Hi All,
I am cheking for whether the datatype is numeric. The coloumn comes with the null value also.
I am using the code;
IsNull(Input) Or IsValid("int32",input) as a constraint in the transformer.
But no rows get tranfered to the output link.
I dont know where I am missing.
Please Advice.
Thanks & Regards,
Kumar66
I am cheking for whether the datatype is numeric. The coloumn comes with the null value also.
I am using the code;
IsNull(Input) Or IsValid("int32",input) as a constraint in the transformer.
But no rows get tranfered to the output link.
I dont know where I am missing.
Please Advice.
Thanks & Regards,
Kumar66
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is not exactly the same topic; you should really start a new one rather than hijack an old thread.
If the constraint expression specifies IsNull(InputLink.ColumnName) then NULL values will be transferred to the output. You want IsNotNull() if what you want to do is to prevent NULL from being transferred.
The original poster in this thread did want NULL to be transferred to output.
If the constraint expression specifies IsNull(InputLink.ColumnName) then NULL values will be transferred to the output. You want IsNotNull() if what you want to do is to prevent NULL from being transferred.
The original poster in this thread did want NULL to be transferred to output.
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.