Eight Stars

Printing SQL Queries generated by Output Components?

We all know that it is possible to print the Insert statement generated by database output components (say tMsqlOutput) by enabling option "Enable Debug Mode".


In my job, i am using Extend Insert option (refer screen for details).

My question is , If 100 records are the source , due to this Extend Insert Configuration I am expecting the talend will generate only single insert statement  with 100 records (because of auto extent) but I see individual insert statements for each output records.


Can anyone help on this , printing the actual query generated in Extend Insert/ Batch mode. 


Thanks in Advance.. 


Re: Printing SQL Queries generated by Output Components?


For t<DB>output component, there is only a global variable QUERY which is the query statement processed. This is an After variable and it returns a string.

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.