Six Stars

tPostgresqlRow not working

Hi community

 

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

Job

tpostgresqlrow.png

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:

tpostgresqlrowConfig.png

 

 

  • Data Integration
  • ESB
1 ACCEPTED SOLUTION

Accepted Solutions
Ten Stars

Re: tPostgresqlRow not working

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

-----------
3 REPLIES
Ten Stars

Re: tPostgresqlRow not working

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

-----------
Six Stars

Re: tPostgresqlRow not working

Thank you, what is the purpose then of tPostgresqlRow?

Highlighted
Employee

Re: tPostgresqlRow not working

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.