I am trying to create a variable and set a dynamic value to it using the below syntax.
DECLARE @my_variable INT.
But it shows syntax error near "@". I tried checking the syntax in the Vertica SQL and i could not find a difference. It would be helpful if someone would help on this or can share your prior experience on the same.
Hi Vamshi,
There is no option to declare a variable in the data jobs, however you can use parameters in Celonis to achieve something similar.
Kindly find the following document for the same.
https://docs.celonis.com/en/parameters---data-integration.html
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
