Six 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

1 REPLY
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