topic Re: Talend Informix TDBRow Not Working in Archived Discussions

Talend Informix TDBRow Not Working

rbabu1607618001 — Thu, 08 May 2025 17:40:29 GMT

Hi Guys,

We are trying to connect to informix database and load the data to our warehouse.

In meta data we create Informix Connection
- Got the table Schema
  - Used table schema as tbinputinformix and moved the date to tboutput [Destination sql server]

Above scenario works fine without issues.

Now we did implemented same approach using TDBRow(Informix), and passed the select statement in it, now it failed

The out we got on checking with tlogrow was

Columnanme

NULL

Works fine with TDBINPUT

(Informix)

, but fails with TDBROW(Informix)

Any thoughts?

Regards,

Ram

Re: Talend Informix TDBRow Not Working

Anonymous — Thu, 21 Jan 2021 07:04:24 GMT

Hello,

tXXXRow component is usually used to any type of sql statement excepts select statement, we use txxxInput component to execute a select statement, if you use use tXXXRow to execute a select statement, it returns a record set, and you are required to use a tParseRecordSet component after tXXXRow to parse the record sets.

Best regards

Sabrina

Re: Talend Informix TDBRow Not Working

Amanda2569 — Mon, 07 Nov 2022 11:41:48 GMT

Thanks for the step by step tutorial. Works like a charm!

official website