Hi folks,
My requirement is to assign a query output(select name from ABC) to the parametre. How can I achieve this, as parametre initialisation is the first thing haapen, once the graph is triggered.
i thought of using the DBExecute component and running the query, but stucked in assigning the value to parametre. Can someone please help me out.
Hi,
Unfortunately, you can’t assign a query output to a parameters during the runtime since they are static and are resolved at the start of the graph. However, I would recommend that you use DBInputTable component and use the Query URL property to read incoming queries to be used in the SQL query attribute through the input port (e.g. port:$0.fieldname:discrete). You can read more about the DBInputTable component here.
I created a query in a reformat before DBInput table and passed that port as query URL, but now i am getting below error :
D:\Users\prabhatn\Desktop
Hi,
Could you please re attach your screenshot, I am not able to see it in your prior post.
Please let me know if there is a way to assign values to parametre
Hi,
I would recommend that you use a Jobflow (you will need CloverETL Corporate Server) to assign the value to the parameter. To accomplish this use case, you will generate the SQL output (select * from ABC) and pass the value to a ExecuteGraph. You will need to create a Parameter in the ETL Graph (e.g. SqlURL) and map this value to the SQL output using the ExecuteGraph component Input Mapping property. Then you can use the Parameter to run the DBInputTable component. I have taken the liberty of attaching both example Jobflow and ETL Graph.
