Update/Insert columns and data into created table

Seven Stars

Update/Insert columns and data into created table

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!!  Smiley Very Happy

 

 

 

 

Employee

Re: Update/Insert columns and data into created table

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

Seven Stars

Re: Update/Insert columns and data into created table

Thanks nikhiltampi!

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

Appreciate it!

I will advise if this works.

Thanks

MM

Seven Stars

Re: Update/Insert columns and data into created table

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

MM

 

 

 

 

Employee

Re: Update/Insert columns and data into created table

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog