I am comparing seq file data with table data. 3 keys combination is used as primary key.
But some of my record's key column values are null. Pls suggest me, how to compare null values?
Issue with null values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 40
- Joined: Sun Jan 21, 2007 1:52 pm
- Location: Chennai
- Contact:
Re: Issue with null values
rajkraj wrote:I am comparing seq file data with table data. 3 keys combination is used as primary key.
But some of my record's key column values are null. Pls suggest me, how to compare null values?
Hi,
You can preprocess it using NVL functions which will replace null with the prescribed text.
regards
Murugan
-
- Participant
- Posts: 32
- Joined: Fri Dec 02, 2005 10:44 pm
- Location: Chicago,IL
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
First, a sequential file has no data types, it contains only text. So it can only contain a "representation" of NULL, not a true NULL.
Second, a key - by definition - can not be null.
Therefore, you may need to re-think your design. If these columns have documented null representations, then the Sequential File stage(s) that read them will convert those representations to true NULLs, in which case the only safe way to test for them is to use the IsNull() function.
Second, a key - by definition - can not be null.
Therefore, you may need to re-think your design. If these columns have documented null representations, then the Sequential File stage(s) that read them will convert those representations to true NULLs, in which case the only safe way to test for them is to use the IsNull() function.
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.