In the next part of this blog series we will look at variables used within TWS. This can be a confusing area especially for those long-time users of TWS as the use of “parameters” and “variables” is sometimes interchangeable. And that’s before we look at when variables get resolved – at job submission time or […]

This blog shows how to configure passing a variable from an event rule to an event action. The example shown passed a variable to the Run Command action, but the same approach can be used to pass it to any event action that accepts arguments. You can check which actions accept arguments by checking the […]

In the next part of this blog series we will look at variable tables. As mentioned in my previous blog, variable tables were introduced with TWS 8.5 and supplement the use of parameter values in earlier TWS versions. Variable tables Variables are held in variable tables which are stored in the TWS database. This provides […]

  Define Common Variable Table Assumptions – all DataStage jobs execute through the same pool or agent workstation. Define a variable table to hold parameters common to all DataStage jobs and ADD the variable table to the pool/workstation definition. Do this by editing the workstation definition and supplying a variable tale value. This will need […]

This blog in the series will look at how to use the TWS built-in File Transfer advanced job type to pull files from a 3rd party site. One of the problems with this type of “pull” transfer is that you can’t be certain that the expected file is actually sitting there on the remote system […]