Page 1 of 1
skip header info from binary file
Posted: Tue May 17, 2011 4:11 am
by srinivas.nettalam
Hi ,
We are receiving fixed width binary files from mainframe environment which contains header info in the first line.we have to skip the first row and load the others.Please suggest a way to do it.
I tried by sending the first record to reject but the job is aborting
Posted: Tue May 17, 2011 6:31 am
by Ravi.K
Is there any identifications to identify header like it starts with "H" etc then write a constraint like as Inputrecord[1,1]<>H. It will load all the records except header record.
Or if you are running job Sequential mode then write a constraint as @INROWNUM<>1.
Posted: Wed May 18, 2011 12:05 am
by srinivas.nettalam
The header gets rejected from the sequential file stage but the job is aborting saying there is import error in the second record which is actually having proper data
Re: skip header info from binary file
Posted: Wed May 18, 2011 12:25 am
by SURA
What you will get, if you read the Binary file using Seq file stage?
Posted: Wed May 18, 2011 6:51 am
by chulett
So, nothing to do with skipping the header and you're already doing that it seems. If you have an import error then you need to post it (copy/paste) before anyone can help.