topic tPostgresqlRow not working in Talend Studio

tPostgresqlRow not working

Anonymous — Sat, 16 Nov 2024 09:28:04 GMT

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:

Re: tPostgresqlRow not working

vapukov — Wed, 02 Aug 2017 01:30:54 GMT

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

Re: tPostgresqlRow not working

Anonymous — Wed, 02 Aug 2017 07:09:44 GMT

Thank you, what is the purpose then of tPostgresqlRow?

Re: tPostgresqlRow not working

Anonymous — Sat, 09 Sep 2017 12:46:15 GMT

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.