Filter commad error in datastage seq files

suri · Post by **suri** » Tue Feb 13, 2007 4:33 pm

Hi All,
In datastage job I reading a file using the SEQ file stage.
file has Header and Footer in it along with column names.
1st record is Header
2nd record is column names
last record is Trailer record
I'm using sed command in the filter comand of the sequential file.
Previously we use to read the file, now we are getting below error.
etlBsl2INTsINVPORT2..INT_INV_PORTFOLIO.lnkGetIntPortfolio: ds_seqopen() - Error in filter command "sed '1d;$d'" -
etlBsl2INTsINVPORT2..INT_INV_PORTFOLIO.lnkGetIntPortfolio: ds_seqopen() - Error in execv() - No such file or directory
etlBsl2INTsINVPORT2..INT_INV_PORTFOLIO.lnkGetIntPortfolio: DSD.SEQOpen GCI $DS.SEQOPEN error 11.
Please can some one help on this.

Thanks
Suri

chulett · Post by **chulett** » Tue Feb 13, 2007 4:37 pm

Post what in have in both the Filename and Filter boxes in the stage.

kumar_s · Post by **kumar_s** » Tue Feb 13, 2007 6:11 pm

Check the Filter command from the command prompt, if it gives the output to the console.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 13, 2007 7:29 pm

For whatever reason, your filter command has failed. There is only one corrective action: fix it. Perhaps you do not check for non-existence of its source file?