Multi Line Comment -> Error: Comment not terminated before end of request text.

[XXX]

Hi together,

I have a problem with comments that are supposed to include several lines in the “DB SQL Executor”
For single lines I use – in front of the line which works well:
– Thats a comment.

But if I want to comment several lines I usually use /* to open the comment and */ to close it.

/*
Thats a comment.
Thats another line of my comment.
*/

But if I execute the node that way I receive the following error:
ERROR DB SQL Executor 0:698 Execute failed: [Teradata Database] [TeraJDBC 16.20.00.12] [Error 3776] [SQLState 42000] Comment not terminated before end of request text.

What am I doing wrong? I’ve terminated the comment with the */, didnt I?

Thanks for your help!
XXX

[julian.bunzel]

Hi @XXX,

it works fine for me. However, I cannot test it with a Teradata JDBC driver. It seems to be related to Teradata.
Usually the way you described is the correct one.

Can you post the whole SQL Statement you are using?

Best,
Julian