Showing results for 
Search instead for 
Did you mean: 

Data Services Designer - Passing Parameter/Variables

Former Member
0 Kudos

Hi everyone!

I am trying to use in my project a parameter/variable to controll the date that my job will process.

For example, if my job executes daily, I want to automatically set the parameter/variable as sysdate. The query within my job will use this date to filter the datas.

How can I do that? I can do that by using parameter or variable?

How is the process to pass this variable (job -> workflow -> dataflow)?

Thanks a lot!!

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Participant
0 Kudos

Create global variable $system_date in your job.

Place a script in front of your dataflow with this statement: $system_date = sysdate();

Use $system_date to filter the data

Former Member
0 Kudos

Yes, it worked.

adding one more information, I used the script component to manage the data.