topic Re: Update/Insert columns and data into created table in Talend Studio

Update/Insert columns and data into created table

rwnetwork — Sat, 16 Nov 2024 04:00:08 GMT

Hi Community,

I'm using components I have not used before and I feel like I have a straightforward task, but I'm not getting the expected results.

I successfully created a table on our idb2/as400 database with 1 column, seen below in link. This was done with the Intermediate Table labeled tas400output component in link below.

https://www.screencast.com/t/VchRK5km

Here is my workflow.

https://www.screencast.com/t/yUOeA7qXNK

Now I need to add more columns from my schema from the previous tfileoutputdelimited file.

Here is my schema from that file. The highlighted blue columns are what I need to add.

https://www.screencast.com/t/w9iwBZpSAQ

I feel I have selected every possible combination of the action items in the tas400output component in link below, but the columns are not adding. I do not receive any error.

https://www.screencast.com/t/tbyDoSeRaiG

Any help from the community?

Please and thank you for suggestions!!

Re: Update/Insert columns and data into created table

Anonymous — Wed, 27 Nov 2019 14:38:29 GMT

Hi,

If the table is already present, it will not rebuild the table. My recommendation will be to take a backup of existing table and drop it. Then the job will identify that table is not present and will rebuild it based on new schema. Please make sure that you are adding length to all varchar columns (the last one in screenshot is not having length data).

I would request to embed the images directly to Talend community website rather than adding links. Many of our community users may be working within enterprise firewalls and they may not have access to all the links (especially screen sharing links).

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Update/Insert columns and data into created table

rwnetwork — Wed, 27 Nov 2019 15:03:48 GMT

Thanks nikhiltampi!

And will take your advice on the links vs the embedded images.

Appreciate it!

I will advise if this works.

Thanks

Re: Update/Insert columns and data into created table

rwnetwork — Wed, 27 Nov 2019 16:19:47 GMT

Hi again,

I'm working on getting higher access to the DB in order to do a drop table step that you suggested.

In the meantime, I am not able to create a new table with a new name just like I did yesterday.

Do you see what I'm missing by chance? (assuming my connections are OK)

Thanks

tas400ouput1.png

Re: Update/Insert columns and data into created table

Anonymous — Wed, 27 Nov 2019 18:03:09 GMT

Hi,

Most probably you might be having less database privileges. You may have to check with admin if this is the case.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved