Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
vasam
Participant
Posts: 30 Joined: Wed Nov 04, 2009 5:06 am
Post
by vasam » Wed Apr 28, 2010 1:39 am
Hi All,
I have a requirement which is i am getting some status like COMT,PEND,FAIL,NULL from my source file. what i need to do is i have to filter the status and send it to each file.
so i had used one switch stage to filter the status, but NULL status is not recognizing in SWITCH stage?
If any NULL comes i have to send this entire record into one file.
how can i do this?
suggest me.
Thanks,
Vijay
vijayakumargoud
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Apr 28, 2010 1:53 am
Is this null or the word "NULL"?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Apr 28, 2010 1:55 am
Moderator: please move to Enterprise Edition (parallel) forum
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vasam
Participant
Posts: 30 Joined: Wed Nov 04, 2009 5:06 am
Post
by vasam » Wed Apr 28, 2010 2:06 am
Thanks for your reply ray..
I have tried both NULL AND is null but its not recognizing.
when i put the condition (other) in swith stage all NULL status records are going to OTHER file.
vijayakumargoud
vasam
Participant
Posts: 30 Joined: Wed Nov 04, 2009 5:06 am
Post
by vasam » Wed Apr 28, 2010 2:07 am
it is word 'NULL '
vijayakumargoud
vasam
Participant
Posts: 30 Joined: Wed Nov 04, 2009 5:06 am
Post
by vasam » Wed Apr 28, 2010 2:58 am
Hi,
Can any body reply to above question?
thanks
vijayakumargoud
udayk_2007
Participant
Posts: 72 Joined: Wed Dec 12, 2007 2:29 am
Post
by udayk_2007 » Wed Apr 28, 2010 3:07 am
I tried using word NULL in switch stage and it is working fine. With null, it doesn't work.
ETLJOB
Participant
Posts: 87 Joined: Thu May 01, 2008 1:15 pm
Location: INDIA
Post
by ETLJOB » Wed Apr 28, 2010 3:22 am
vasam wrote: it is word 'NULL '
It seems the word 'NULL' is working fine in Switch.
I could see a space after the word 'NULL', in your post. I hope, its a typo error. If it is not the case then remove that space in your job and give a try.