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;
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.
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.
