Talend Using Custom SQL Template

Question

So i would like to use the tSqlTemplate componente to delete all entries from a MySql database table. Should be simple enough:

here is the what the template looks like:

however i can't do anything with it, since i am unable to select it:

as you can see, the button "Hinzufügen" (meaning "add") is greyed out, meaning i cant add anything there. Then what is the use of the component?

For unidentified reasons it just started to work. Additionally a ';' was missing.

Answer 1

For unidentified reasons it just started to work. Additionally a ';' was missing.

Answer 2

Why do you want to use tSQLTemplate?

It seems like you could just use tDBRow and execute your deletion query there.