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