context load logic

[Anonymous]

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

[Anonymous]

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