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
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.
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
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers