talend

How to display Talend tDbRow output?


I have to output the result of the query in tDbRow, here "show datestyle;" in a Postgresql database as an example.

What i did :

tDbRow parameters

Advanced parameters

And now, how do i display the output object ? Sadly, the globalMap.get("tDBRow_1_QUERY") only shows the query.


Solution

  • Ok found it :

    1. dbRow sould output an object variable
    2. use of tParseRecordSet as describe in screenshot : create an attribute line with value in position 1
    3. display the value with tLogRow

    talend workflow with tDbRow

    Below : result of Show datestyle;

    Result of execution