"Formatting several Read Database queries at once"

jaakko1

Hello all,

I have a process with ten different "Read Database" operators that all include an SQL script with a date in them. I would like to be able to change this date on all the operators at once without having to click through all the operators and change the date individually. Is there a way to do this? Many thanks again in advance for your help.

Marco_Boeck

Hi,

you can use macros for that. For example, using the following query in a Read Database operator replaces the FROM clause with the macro value specified:

SELECT %{name} FROM test;

To set a macro you can either define it in the process context (View -> Show View -> Context) or use one of the macro operators.

Regards,
Marco