topic Re: Printing SQL Queries generated by Output Components? in Talend Studio

Printing SQL Queries generated by Output Components?

ashif2 — Sat, 16 Nov 2024 09:19:15 GMT

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?

Anonymous — Thu, 21 Sep 2017 11:14:45 GMT

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

Re: Printing SQL Queries generated by Output Components?

Anonymous — Mon, 27 Aug 2018 07:40:07 GMT

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,

Re: Printing SQL Queries generated by Output Components?

Dobby1 — Sun, 08 Mar 2020 16:35:21 GMT

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.