context load logic

Seven Stars

context load logic

Hi all,

 

I have created table say tbl_context_load with columns(key, values).

 

Key is constant and values keep changes over runs.

 

using tOracleRow1 :

i want to insert context variable values.

ex: insert into tbl_context_load values("first_name", +context.first_name);

insert into tbl_context_load values("second_name", +context.second_name);

 

after that i want to use this context variables to other independent job using tcontextload

 

How to achieve and let me know the insert statement is correct?

 

Thanks

Shree

Community Manager

Re: context load logic

Hi
Take a look at this article which explains how to execute multiple statements on a tOracleRow.
https://community.talend.com/t5/Troubleshooting-Installation/Executing-multiple-SQL-statements-with-...

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch