Hi All,
I need write custom XML, that contains list of child's for each element. for that i am using XML template and SQLexcuter. but the problem is for SQL execute need to pass the value as a dynamic.
SQL excute transfer fallowed by creater trasformer.
ex : Create-->SQLexcuter
ex : Create-->SQLexcuter
ex : Create-->SQLexcuter
I need to pass Id values for Common.
Please help on this.
+45Hi @kumarc,
I simulated here creating a Publish Parameter a Id.
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.
Hi @kumarc,
I simulated here creating a Publish Parameter a Id.
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
+45
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.
+13Hi @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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
