topic Re: Commenting queries in tSQLrow in Talend Studio

Commenting queries in tSQLrow

tYrannoSaurusRex_1 — Fri, 04 Apr 2014 10:28:39 GMT

Hi,
I have used multiple queries in tSQLRow to test various test cases of data inserted. Say I have 5 queries, and I want to have only 2 queries running, how do I comment non-required queries in the query editor???
Example:
//select count(*) from sample_log;
or
--select count(*) from sample_log;

Re: Commenting queries in tSQLrow

Anonymous — Fri, 04 Apr 2014 14:32:52 GMT

If you want to do this, you're probably better of defining a global variable in tJava, where you can comment out the different assignments. You can then reference this in your tSQLRow.

Re: Commenting queries in tSQLrow

Anonymous — Sat, 05 Apr 2014 23:05:05 GMT

Talend has the annoying behavior the remove all line breaks an therefor a line comment will hide all following sql code even the code in all following lines.
I suggest you use the block comment /* comment */. This kind of comment will processed correctly.