Automation Designer with Variables

[Gary.Jerep]

Probably several ways to do this... here's one way, where you can use the ampersand character to designate a variable, for which you can set a default value, and also get prompted during the run (note that I had to double up on the period for proper parsing) ...

Here's another useful link describing a different way to utilize variables, and probably a little more flexible.. from our lead developer Mr. Dorlon:

Using Variables in a Toad Automation Query

Hello! I am attempting to use a variable in a query in the Toad automation designer (v12.11). In control, I use the Create Variable step and I put VAR_CP for variable and TEST for value. Scope is Local (current run). The next step is a script step. Eventually, this will be an update such as: Update MYTABLE set x=3 where MyValue=VAR_CP I’ve tried a lot of different ways to do this: MyValue=@VAR_CP MyValue=:VAR_CP MyValue=VAR_CP MyValue=‘VAR_CP’ MyValue=’@VAR_CP’ etc - The error in al…