How to read query result and put the output into a txt file

[Anonymous]

Hi,

I need to call a stored procedure from talend and then putting the output into a .txt file. How can I do that? Does anyone can help me please? I know ho to call the procedure but I do not know how to store the result in order the put the output in a txt file. I am using Postgres as DB.

[David_Beaty · Accepted solution]

Hi,

have a a look at the tParseRecordSer component.

thanks

david.

[Anonymous]

You can also use a tPostgresqlInput component because PostgreSQL allows to call a procedure with a select!

select field_1, field_2 from my_procedure()

[Anonymous]

Hi,

thank you for your response. I am trying to use it, but I am getting the following error: "Cannot Cast from String to Result Set". I am doing a simple select from myTable which as one column of varchar2. As database I am using Postgres.

My job is dbTable (input) -> tParseRecordSet -> tFileOutputDelimited

[Anonymous]

This is my new job. I added tMap. I did not get the error anymore, but output file has not been created. Is there a reason? Am I doing something wrong?

Than you in advance.

[Anonymous]

I am sorry! I tried again and I am getting the same error now

[Anonymous]

[solved]

I solved the issue. The job is made up of tPostgresqlInput linked to tInputFileDelimeted and it works. Pay attention to " " in Row Separator and Fiel Separator of tInputFileDelimeted.