how to with tMap to define constants

[Anonymous]

Hello everbody,

I'm in front off a problem that I don't find how to solve to: I'm fetchning from an oracle database a field value. this value must be updated in an mysql database throw an update with two constants in a where row: UPDATE my_table SET my_field = oraclevalue WHERE field = 'firstField' AND secondField = 'secondField';
So my batch is based like the following one:

But from and to field are not variables but must be static values. How can I define their values ? Does I need to update the model? Does I need to update job to fetch the row matching from Mysql Database server and update it?
Best

[Anonymous]

When I was talking about the CTRL+Space I?m talking about variables declared in the Contexts (second tab, between Job and Component). Did you declare your variables there?
Using context variables is only one way to deal with the situation but it is the way with the CTRL+Space.

[Anonymous]

Hello,
well I've tried this way too. I have defined in a conversion 1.0 context variable in left menu two variables, FROM and TO. But in this case too, I can"t see them in ctrl+space context.

Perhaps could you post me a screenshot on the way to define theses variables, I'm sure I'm passed next something ...
Best regards,

[Anonymous]

.

[Anonymous]

really thanks you for your help
just one last question: what is the difference between global variables defined in t_globalvar, context, and these kind of variables?

[Anonymous]

Hi,

in t_globalvar you define global variable for the job
in context you can create differente situation (prod,dev) with different value for the context variable. When you generate scriptjob you can choose the context (and the values of the context variable) to execute the job on the server.
After you can use "implicite tConextLoad" in the wiev job>extra : we load values of context variable from a files or data base (key;value)
For me, It's the unique interacrtion between user and job script on the server.

best regards

jeremie