Filter commad error in datastage seq files
Posted: 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
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