skip header info from binary file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
srinivas.nettalam
Participant
Posts: 134
Joined: Tue Jun 15, 2010 2:10 am
Location: Bangalore

skip header info from binary file

Post 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
N.Srinivas
India.
Ravi.K
Participant
Posts: 209
Joined: Sat Nov 20, 2010 11:33 pm
Location: Bangalore

Post 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.
Cheers
Ravi K
srinivas.nettalam
Participant
Posts: 134
Joined: Tue Jun 15, 2010 2:10 am
Location: Bangalore

Post 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
N.Srinivas
India.
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: skip header info from binary file

Post by SURA »

What you will get, if you read the Binary file using Seq file stage?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply