Hi, The Execute SQL script is a row processing transform, it requires input rows to work. The values used to replace the ? Need to come from a field in the stream.
The simplest way to make your example work is to add a Data Grid transform [1] to the canvas, in the Meta tab create a field named “colour” (type string). In the Data tab you can then add the value “Green”. Then you can use this “colour” field in the Execute SQL Script transform (where you now have written Green). Hope this helps, Hans [1] https://hop.apache.org//manual/latest/pipeline/transforms/datagrid.html On 18 April 2023 at 08:20:41, Md Sahabaj Ansari ([email protected]) wrote: Hi, Greetings of the day !! My question is how I replace question mark (?) value with arguments in Execute Sql scrpt. My value is Green here. Thanks, Md Sahabaj Ansari Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
[email protected]
Description: Binary data
