Page 1 of 1

Filter commad error in datastage seq files

Posted: Tue Feb 13, 2007 4:33 pm
by suri
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

Posted: Tue Feb 13, 2007 4:37 pm
by chulett
Post what in have in both the Filename and Filter boxes in the stage.

Posted: Tue Feb 13, 2007 6:11 pm
by kumar_s
Check the Filter command from the command prompt, if it gives the output to the console.

Posted: Tue Feb 13, 2007 7:29 pm
by ray.wurlod
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?