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
h4rd1
Participant
Posts: 8 Joined: Mon Oct 19, 2009 2:09 am
Post
by h4rd1 » Fri Nov 13, 2009 6:59 pm
Dear all
i'm new in using datastage, do any one know how to filter a data from source base on the date supply by database ?
Thanks
Hardi
kduke
Charter Member
Posts: 5227 Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
Post
by kduke » Sat Nov 14, 2009 12:20 am
You have to either join to get the date or write a job just to extract the date and write it to a sequential file. Have another job or routine read this date a feed it as a parameter to the main job.
Mamu Kim
h4rd1
Participant
Posts: 8 Joined: Mon Oct 19, 2009 2:09 am
Post
by h4rd1 » Sat Nov 14, 2009 10:55 am
Thanks for the Reply
Can i directly do that in the job ?
Thanks
Hardi
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Sat Nov 14, 2009 12:58 pm
No.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sat Nov 14, 2009 3:10 pm
I don't see why not - providing this "filtering" can be done in the source query. To be honest, though, I didn't really grok the original question.
-craig
"You can never have too many knives" -- Logan Nine Fingers
vjonnala1516
Participant
Posts: 18 Joined: Fri Jan 04, 2008 5:28 am
Location: Bangalore
Post
by vjonnala1516 » Sat Nov 14, 2009 7:50 pm
just keep the filter/constraint in the base query itself.
VJ
h4rd1
Participant
Posts: 8 Joined: Mon Oct 19, 2009 2:09 am
Post
by h4rd1 » Sun Nov 15, 2009 7:12 pm
Thanks for the Help
i use parameter set and i add a job that supply the value into the parameter job file.
Thanks