Question
Cursors in transformation
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
Hi Akash,
can you please specify if youre 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
Best,
Viana
Login to the community
No account yet? Create an account
Login with SSO
Celonaut Login Celonis ID LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.