Retrieve database script output in talend

[Joe20201]

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

[iamabhishek]

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.

[Joe20201]

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.

[jerome_dal]

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.