Hello,
Is there a way to dynamically define a variable in the Variables and Promptset Tab?
https://us.v-cdn.net/5019921/uploads/editor/wp/in2x9sa4rw1i.png" width="466">
I know I can do this in Pre-Process of a Workflow and have that be inherited to the job. But I'd like to define this directly in the job, and then be able to in the Prompt set use that value.
https://us.v-cdn.net/5019921/uploads/editor/ax/5wqx7nnoro0n.png" width="577">
Thanks
We do this with SQL variables... so on V&P tab..
&CURRENT_DATEINT_MINUS_1# | {VARA.SQL.DATEINT_MINUS_1D}
Then create VARA.SQL.DATEINT_MINUS_1D as (depending on your DB)...
SELECT to_char(sysdate-1,'YYYYMMDD') FROM dual
We do this with SQL variables too. We have set up a global pool of date variables so they are easy for staff to find and re-use.
Since there are some date calculations that can not be done with a SQL statement, we also run a script at midnight to populate static date variables. This allows us to store all of our complex date logic inside of a single script and the results can be re-used by multiple solutions.