giving different outputs

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
ntr
Participant
Posts: 110
Joined: Fri Dec 18, 2009 10:30 am
Location: pune

giving different outputs

Post by ntr »

i had executed sed '1d' command in external filter stage it removed first line in the file same command i had used in sequential file filter it had redmoved first two records.if i use sed '2d' in sequential filter it is removing 2nd and 3rd
can you please suggest me why its giving like that


Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Do you have "first line is column names" set in the Sequential File stage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pradeep9081
Participant
Posts: 30
Joined: Tue May 11, 2010 2:05 pm

Re: giving different outputs

Post by pradeep9081 »

I think you are running on two node configuration file ... so its deleting first two records. Try running the same job with single node configuration file.
ntr
Participant
Posts: 110
Joined: Fri Dec 18, 2009 10:30 am
Location: pune

Re: giving different outputs

Post by ntr »

Hi @Ray i had set firstline colum names as false

pradeep9081--- iam running on 4node configfile but the stages are executing sequentially

Thanks
ntr
Participant
Posts: 110
Joined: Fri Dec 18, 2009 10:30 am
Location: pune

Re: giving different outputs

Post by ntr »

when i had used that sed '1d' in source sequential filter also its working fine. but if i use same in target sequential its removing two records first and second as well as if i place sed '2d' its removing 2nd and third record .

@ray i had tried by changing of firstlinecolums true as well as false also

pradeep9081 -- i had ran it on single node also


Thanks
ntr
Participant
Posts: 110
Joined: Fri Dec 18, 2009 10:30 am
Location: pune

Re: giving different outputs

Post by ntr »

any body know the reason?


Thanks
Post Reply