Thanks Hans !! it works . could you also let me know to capture the logging info in txt file . when I run a pipeline it save the logging in hopgui.log under audit folder and when I close it also erased . I want to save the logging for every pipeline in separate txt file .
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows From: Hans Van Akelyen<mailto:[email protected]> Sent: 18 April 2023 01:02 PM To: Md Sahabaj Ansari<mailto:[email protected]>; [email protected]<mailto:[email protected]> Subject: [EXTERNAL] Re: How to replace Parameter with ? question mark 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<https://hop.apache.org/manual/latest/pipeline/transforms/datagrid.html> On 18 April 2023 at 08:20:41, Md Sahabaj Ansari ([email protected]<mailto:[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. [cid:[email protected]] Thanks, Md Sahabaj Ansari Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
