Hi , i am trying to use sql cursor in transfornation job but every time i execute it it shows " error near or at @". I am using @ to declare variable for eg @sample int
can you please specify if you’re using Celonis IBC or Celonis On-premise?
I assume that you are using Celonis IBC, please note that the sql dialect Vertica is used on there. It is not possible to declare variables with @ in your script.
I suggest to rather use the parameters instead. You can find more information about parameters on https://help.celonis.cloud/help/display/CIBC/Parameters