topic Re: Why tOracleRow filter the rows? in Talend Studio

Why tOracleRow filter the rows?

Anonymous — Sat, 04 Jan 2014 20:49:36 GMT

Hello,
I want to make an sql to a table in order to look up for a date if exist, and if does not exist, show a null but i dont want to filter the row if the query doesn't gives a result
My sql is
select 'YES' as RESULT from table where fieldA > '50'
Thanks

Re: Why tOracleRow filter the rows?

Anonymous — Sat, 04 Jan 2014 21:22:11 GMT

I would select the amount of datasets.

select count(1) as count_ds from table where fieldA > '50'

This query returns always as value and you can filter for 0 or greater 0.

Re: Why tOracleRow filter the rows?

Anonymous — Sun, 05 Jan 2014 15:31:55 GMT

the component tOracleRow does not filter at all. I guess you are working with the component tParseRecordset? This component returns as much output rows as the result set of the query have rows.

Re: Why tOracleRow filter the rows?

Anonymous — Mon, 06 Jan 2014 03:26:57 GMT

Hi,
We usually use t<DB>Input to execute a select query, you have to use a tParseRecordSet after t<DB>Row to parse the record set if you use t<DB>Row to execute a select query.
Best regards
Sabrina