Toad World® Forums

Automation Designer: Query Iterator using variable?


#1

Hello,

I am wondering if it’s possible to use a variable inside the query of an SQL Query Iterator in the Automation Designer?

Example:

SQLQueryIterator.jpeg

The idea behind this is to then use a Variable Prompt to set the value of the variable used in the SQL Query Iterator’s WHERE CLAUSE at runtime.


#2

Why not put the query iterator inside another query iterator? Or inside a list iterator.


#3

Sorry this isn’t possible right now but I’ll see if I can add that for you.

I guess this is just an example, but you might want to look at some of the other iterators…you might be able to do what you want with file or list iterators.