Issue with null values

[rajkraj]

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?

[DSguru2B]

Preprocess the inputs and replace NULL values to a default value for comparison.

[muruganr117]

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

[pradeepleon]

Replace the NULL values to a default value then do the comparison.

[ray.wurlod]

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.