Hey guys,

is it possible to set a system variable of the MySQL server dynamically during a transformation in kettle? I tried the following:

Step 'Execute SQL Statements': SET SESSION group_concat_max_len = ?;

The question mark is replaced by an argument of the step before. But even if I place an absolute value there instead of the question mark, it's still not working. The following steps, e.g. a table input step, will ignore the modified session variables so the default system values are used.

Setting the system variable globally on the whole connection (and not only for the session) is no option in my case. Using PDI 5.0.7, MySQL 5.1.73.

Many thanks,
tba