Null Handling in Datastage

NULL cannot be defined. Values coming in column-’NULL’, '   ' do not represent the value to be NULL.

In Datastage, records are dropped or can be captured from reject link if the column value contains NULL. Sequential file can read NULL values if we give the default value to NULL while reading.

If the metadata contains the many columns which can contain NULL values and you need to read all records then Property need to set at file level.

Go to- Sequential File stage >> Output >> Format >> Field defaults >> <Specify default value which will help to identify the NULL value>

 

Note: In Column tab, column in which NULL are expected should be marked nullable as ‘Yes’

If the metadata contains only one column /few columns which can contain NULL values and you need to read all records then Property need to set at column level.

Go to- Sequential File stage >> Output >> Columns>> Click on extended properties (marked in yellow) >> <Specify default value which will help to identify the NULL value>