Strange that it works on Windows but not on Linux.
Is your IDPROCESS variable as String, Integer or any other data type?
If it's a String, your insert statement should have (single) quotes around
the variable: VALUES ('${IDPROCESS}', 'In Progress', NOW(), null);
If your IDPROCESS values are integers, your current statement should work.Regards, Bart On Fri, Aug 25, 2023 at 9:10 AM Eric <[email protected]> wrote: > Hi, > > In a pipeline, I generate a variable using JavaScript called "idprocess," > which is the current date and time in milliseconds. Then, I perform the > "Set Variable" transformation and refer to that variable as "IDPROCESS." > In the main workflow, I call that pipeline and subsequently execute an SQL > script where I perform an insert into the database using the "IDPROCESS" > variable: > > INSERT INTO camerfirma.ctl_process (idprocess, status, fecha_inicio, > fecha_fin) > VALUES (${IDPROCESS}, 'In Progress', NOW(), null); > > On Windows, this script functions correctly and inserts the "idprocess" > into the database. However, on Linux, I encounter the following error: > > SQL - ERROR: syntax error at or near "$" > > Thanks. > > El vie, 25 ago 2023 a las 1:02, Diego Mainou (< > [email protected]>) escribió: > >> Hi Eric, >> >> You'll need to give us more info >> >> >> <https://www.bizcubed.com.au> Diego Mainou >> Product Manager >> M. +61 415 152 091 >> E. [email protected] >> www.bizcubed.com.au <https://www.bizcubed.com.au> >> >> ------------------------------ >> *From: *"Eric" <[email protected]> >> *To: *"users" <[email protected]> >> *Sent: *Friday, 25 August, 2023 5:01:15 AM >> *Subject: *Problem in Linux >> >> Hello >> >> >> >> I’ve been experiencing issues on Linux. I’ve developed an ETL process in >> witch I generate a variable that i subsequently use for an INSERT operation >> using an SQL script. It Works fine on Windows, but on Linux the variable is >> not recognized. What could be the issue? >> >> >> >> Thanks >> >> >> >>
