topic Re: Retrieve database script output in talend in Talend Studio

Retrieve database script output in talend

Joe20201 — Sat, 16 Nov 2024 00:42:27 GMT

I have created a validation framework in talend which uses database script output(return message) . So,

I am trying to retrieve database script output in talend such as "table created", "table dropped" etc on execution of sql script using tdbrow . Could you please guide me the steps to implement this in talend.

Re: Retrieve database script output in talend

iamabhishek — Tue, 02 Feb 2021 15:04:48 GMT

There is a global variable (((String)globalMap.get("tDBRow_1_QUERY"))) associated with database specific tdbrow components. Take a look into that and see if that's useful as per your use-case.

QUERY: the query statement being processed. This is a Flow variable and it returns a string.

Re: Retrieve database script output in talend

Joe20201 — Mon, 01 Mar 2021 09:46:55 GMT

Thanks for your input @Abhishek Chakraborty . I noticed that the global variable (((String)globalMap.get("tDBRow_1_QUERY"))) is used to display/print the query that we use in the database input components such as tdbrow or tdbinput etc.

My question is once we execute the query, how to retrieve the database response of the executed script for example- Table created, Table dropped etc.

Re: Retrieve database script output in talend

jerome_dal — Tue, 17 Oct 2023 11:35:44 GMT

Hello,

Have you found a solution?

I have the same problem: I use a JDBC connection in the tDBRow to execute a DELETE statement, and I would like to get the count of deleted rows.