Posted: Sun Feb 09, 2003 6:34 pm
Write a simple server job that retrieves the date from the Database and writes it to a text file.
Write a routine that opens the text file and reads the date and returns this date to the calling job.
In your first Sequential job run the server job that saves the date to a text file, run the routine that retrieves the date from the text file. Now link this routine output to all subsequent server jobs and pass the routine ReturnedValue to those jobs as job parameters. If your routine stage is called GetDate then the job parameter will be set to GetDate.ReturnedValue. You can type this into the parameter value box or you can pick it from the list of available parameters by clicking the parameter button. Just make sure you have a sequence of links from your GetDate stage to all the jobs that will use that date.
I know you don't want to do much coding however opening a text file and reading the first line is very easy! Just check out the sequential file commands in the DataStage programming manual or do a search for OpenSeq in the archives of this site.
Vincent McBurney
Data Integration Services
www.intramatix.com
Write a routine that opens the text file and reads the date and returns this date to the calling job.
In your first Sequential job run the server job that saves the date to a text file, run the routine that retrieves the date from the text file. Now link this routine output to all subsequent server jobs and pass the routine ReturnedValue to those jobs as job parameters. If your routine stage is called GetDate then the job parameter will be set to GetDate.ReturnedValue. You can type this into the parameter value box or you can pick it from the list of available parameters by clicking the parameter button. Just make sure you have a sequence of links from your GetDate stage to all the jobs that will use that date.
I know you don't want to do much coding however opening a text file and reading the first line is very easy! Just check out the sequential file commands in the DataStage programming manual or do a search for OpenSeq in the archives of this site.
Vincent McBurney
Data Integration Services
www.intramatix.com