Talend Informix TDBRow Not Working

[rbabu1607618001]

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

[Anonymous · Accepted solution]

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

[Amanda2569]

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

official website