Printing SQL Queries generated by Output Components?

[ashif2]

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

[Anonymous]

Hello,

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

Sabrina

[Anonymous]

Hi ,

Can u please tell me how to get the insert scripts from source like as txt,csv,xlsx .i need .sql file as output which have insert scripts.

Advance thanks,

[Dobby1]

I don't think the QUERY variable is available on tDbOutput components. I'm also looking to print the actual Insert statement that Talend generates.