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.
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. -
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.
Please sign in to leave a comment.
Comments 5