DSXchange

im extracting date field from a flat file and want to use this date as parameter to use in other jobs where i have to query other tables on this date. How can i do that. Or any other suggestion.

One way might be using the batch subroutine to read and extract date field from the file. The value can be set as the parameter using DSSETPARAM function to set the value for parameter for individual jobs.

One way might be using the batch subroutine to read and extract date field from the file. The value can be set as the parameter using DSSETPARAM function to set the value for parameter for individual jobs.

Create a job sequence.
Construct an Execute Command activity to execute the command to read the date from the file (or use a Routine activity that invokes a routine to do the same).
Pick up this value as the output value of the command (or the return value of the routine) when setting the job parameter in the downstream Job activity.