topic tOracle Output show querry in Talend Studio

tOracle Output show querry

Anonymous — Tue, 12 Sep 2017 09:26:05 GMT

Is there a way to print the querry used in tOracle Output component?

Anonymous — Tue, 12 Sep 2017 09:52:37 GMT

Hello,

Here is a global variable tOracleoutput.Query which is the query statement processed. This is an After variable and it returns a string

Note: You have to check the advanced setting "Enable debug mode" for that globalMap variable to be populated.

Best regards

Sabrina

Anonymous — Tue, 12 Sep 2017 09:56:35 GMT

Hello,

You can print out the query on to the console by using System.out.println(((String)globalMap.get("tOracleOutput_1_QUERY"))); in the tJava component.

Let us know if it is OK with you.

Best regards

Sabrina

Anonymous — Tue, 12 Sep 2017 10:13:09 GMT

After I enabled debug mode in the component it works

Anonymous — Wed, 13 Sep 2017 04:14:15 GMT

Hello,

Great it works. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina