Blank Rows are not Read by Datastage

KFajardo · Post by **KFajardo** » Sun May 24, 2015 6:22 am

Hi guys,

good evening.

I have a problem on extracting a flat file on datastage.

The blank rows are ignored when extracting the data from a flat file.

is there a way that Datastage will consider those blank rows as NULL?

Any help please?

Thanks,
keith

chulett · Post by **chulett** » Sun May 24, 2015 6:57 am

Just a quick note. When you have a question about Parallel jobs you should be posting them in the EE/PX forum. Saves me from having to move everything for you as I've been doing. Thanks.

chulett · Post by **chulett** » Sun May 24, 2015 6:58 am

Define "blank row" for us. Complete empty, all spaces or ???

KFajardo · Post by **KFajardo** » Sun May 24, 2015 9:57 am

Ah, sorry for that. I will next time.

OK, blank rows.

In my sequential file, it is only blank.

I think it has a line feed so it is not null.

When i extract in on datastage, Datastage neglects the "blank" rows and proceeds to the next row.

chulett · Post by **chulett** » Sun May 24, 2015 12:59 pm

Not neglected but rather rejected since they did not match the metadata. They can either be captured via a reject link and processed separately or in your case you should check into the "Reject Mode" property of the stage, see if one there would help with this.