How to trap NULL record

[Ujjwal]

In some cases when we use FTP to read files, we get a NULL record at the end and hence we get a warning in the log saying record dropped.
But due to this my Sequence job fails as we have condition as status 2 or status = 3 as failure.
How do we trap this NULL RECORD problem

error log msg im getting is

"Trans_crncy,1:Field 'Description' from input dataset-'0' is NULL Record dropped"

[roy]

Hi,
You can try to preprocess the file and strip off the empty records.

this is do-able via a ds job, using Os commands such as sed (ask you system admins if you need help on the sed command)
or by combining the 2 (like using the filter option of a sequential file stage).

It was also covered before, you can search for the answer using the search utility of this forum.

IHTH,

[Ujjwal]

In some cases when we use FTP to read files, we get a NULL record at the end and hence we get a warning in the log saying record dropped.
But due to this my Sequence job fails as we have condition as status 2 or status = 3 as failure.
How do we trap this NULL RECORD problem

error log msg im getting is

"Trans_crncy,1:Field 'Description' from input dataset-'0' is NULL Record dropped"

=====================
in order to remove # from src file we are giving condition like first column name[1,1]<>'#' in transformer constraint but it is throwing warning
kindly reply soon treat it as urgent

[meena]

Hi Ujjwal,
Roy is correct, You can use sed command in the DS job. Nor you can write a contraint, saying that the "output stream is not equal to NULL" if you have used a transformer in your DS job.

Meena

In some cases when we use FTP to read files, we get a NULL record at the end and hence we get a warning in the log saying record dropped.
But due to this my Sequence job fails as we have condition as status 2 or status = 3 as failure.
How do we trap this NULL RECORD problem

error log msg im getting is

"Trans_crncy,1:Field 'Description' from input dataset-'0' is NULL Record dropped"

=====================
in order to remove # from src file we are giving condition like first column name[1,1]<>'#' in transformer constraint but it is throwing warning
kindly reply soon treat it as urgent

[aramachandra]

Have you tried to handle the null value by setting the null field value with empty quotes in the extended properties of the column where you have null in the source files.

arvind