Automic Workload Automation

Expand all | Collapse all

Define Dynamic Variable in Variables & Prompset Tab

  • 1.  Define Dynamic Variable in Variables & Prompset Tab

    Posted 04-29-2014 07:13 PM

    Hello,

    Is there a way to dynamically define a variable in the Variables and Promptset Tab?

    in2x9sa4rw1i.pnghttps://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.

    5wqx7nnoro0n.pnghttps://us.v-cdn.net/5019921/uploads/editor/ax/5wqx7nnoro0n.png" width="577">

    Thanks



  • 2.  Define Dynamic Variable in Variables & Prompset Tab

    Posted 04-29-2014 08:24 PM

    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



  • 3.  Define Dynamic Variable in Variables & Prompset Tab

    Posted 04-30-2014 02:29 PM

     

    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.