Change the Schema of the DB2 Output

Five Stars

Change the Schema of the DB2 Output

Dear all,


in my talend job i created a context containing the connection to a DB2 database, creating all the Schema that the Job needed. The problem is that if I open a single connection to the DB I can only indicate a Schema, so if the DB in which I want to write has a different schema, it gives me an error.


Is there a way to change the Schema of the output DB without having to create two connections to the same database?


or a stage for the command DB2?






Re: Change the Schema of the DB2 Output


You can use centralized DB2 metadata in your job and retrieve a schema based on one of the loaded table schemas, select the database table schema name in the drop-down list and click Retrieve schema.

With you context connection requirement, you can export the connection details to a new context group in the Repository for reuse in other connections or across different Jobs, or reuse variables of an existing context group to set up your metadata connection. 

For more information, please have a look at this online documents about:TalendHelpCenter:Centralizing database metadata and TalendHelpCenter:Exporting metadata as context and reusing context parameters to set up a connection

Best regards




Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.



Introduction to Talend Open Studio for Data Integration.


Downloads and Trials

Test drive Talend's enterprise products.