tPostgresqlRow not working

[Anonymous]

Hi community

I am getting NO results back from my tPostgresqlRow. All fields return null:

Job

Sql for tPostgresqlInput_1:

select distinct (account_id) as account_id from edw_dev.d_customer_account
 where account_id in( '1-DXQFNF') ;

Sql for tPostgresqlRow_1

select distinct account_id,account_sk from edw_dev.d_customer_account
 where account_id in ( '"+((String)globalMap.get("row1.account_id"))+"' )

Schema Config for tPostgresqlRow_1:

[vapukov · Accepted solution]

to continue our discussion

use tPostgreSQLInput instead or tPostgreSQLRow  if You want return data

use the same query, just change component

or look for - https://help.talend.com/search/all?query=Configuring+the+tParseRecordSet+component

[Anonymous]

Thank you, what is the purpose then of tPostgresqlRow?

[Anonymous]

The purpose of all *Row component is to call stored procedures or other DB commands like DDL etc.  The component do not do the handling of the data back. You will need to use the tParseRecordset component to extract the data returned in the recordset object.  Some DDL command will not even return a value, others will return a count, etc.  

You should use Input components for Select statements, and Output component for update etc.