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
>
>
>
>
