Hi @kumarc,

I simulated here creating a Publish Parameter a Id.

1. Navigator -> Published Parameter :

2. Into transformer SQLExecutor : Search the option Published Parameter ( _int ) and insert in your script:

3. Execute with Mode Prompt and fill the value your Id:

Thanks,

Danilo

---

Thanks for quick response,but this is not my case.

step 1 : I created parameter with default value.

step 2 : i executed SQLexcuter transfer.and get the value.

step : i need to assign the value to parameter. here how can i do this ? with out linking or Connect .?

Thanks for help.

the parameter value need to change run time (ex : attribute setter or parameter setter or attribute manger) accordingly, i need to map the value. instead of enter.

---

Thanks for quick response,but this is not my case.

step 1 : I created parameter with default value.

step 2 : i executed SQLexcuter transfer.and get the value.

step : i need to assign the value to parameter. here how can i do this ? with out linking or Connect .?

Thanks for help.

the parameter value need to change run time (ex : attribute setter or parameter setter or attribute manger) accordingly, i need to map the value. instead of enter.

I explained the problem above Could you please help on it .

 

 

---

Hi @kumarc,

I simulated here creating a Publish Parameter a Id.

1. Navigator -> Published Parameter :

2. Into transformer SQLExecutor : Search the option Published Parameter ( _int ) and insert in your script:

3. Execute with Mode Prompt and fill the value your Id:

Thanks,

Danilo

Can i Change the parameter value run time ? it means useing AttributeCopier i need set the value. if is possible ?

---

I explained the problem above Could you please help on it .

 

 

Yes, is possible to map a value of instead enter value with puslish parameter, like i demonstrated you.

 

 

---

Yes, is possible to map a value of instead enter value with puslish parameter, like i demonstrated you.

 

 

Dear danilo,

 

 

Thanks for response, please understand my question. my question is as flows below steps.

 

 

Step 1: I created blank workbench.

 

Step 2: then i added Creator transformer.

 

Step 3: after that i Created user parameter (ID) as you explained and i set that parameter value is Zero(0).

 

Step 4 : Then i read oracle data using SQL Executor, after execute,i received ID values as 100 . Question 1 :Here How can i set the SQL result value to that user parameter. ( like attribute manger)

 

Step 5: Then again i inserted one more Creator transformer fallowed by SQL Executor

 

in this SQL Executor the query builder values should read from user parameter.

 

Note : the user parameter should be change dynamically not constant value.

 

if possible please create sample workbench and explain.

 

 

 

 

 

 

---

Hi @kumarc - After reading over this thread, there are a few different ways you may be able to end up where you want... I think that I would have to know more about what is returned by your SQLExecutor (i.e. Results Port), and the larger picture – i.e. is this a chained workflow? I think it would help if you can share your workspace (.fmw) with any relevant annotations.

VariableSetter / VariableRetriever: These transformers will allow you to set and retrieve variables in a workspace. This would remove the need to have transformers directly connected, per se.

WorkspaceRunner: You can leverage this transformer to chain together pieces of your overall solution. The WorkspaceRunner allows you to populate the values of Published Parameters with attribute values determined earlier in the workflow.

Custom Transformer: By wrapping the SQLExecutor in a custom transformer, you could achieve similar results to using the WorkspaceRunner.

---