DSXchange

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

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.

Thanks for the Reply

Can i directly do that in the job ?

Thanks


Hardi

No.

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.

just keep the filter/constraint in the base query itself.

Thanks for the Help

i use parameter set and i add a job that supply the value into the parameter job file.

Thanks