I want to convert this syntax from SQL SERVER to TERADATA:
When i'm running in TERADATA this syntax:
CAST(DecryptByKey(A.LastName) AS VARCHAR(8000))
I'm getting an error:
Executed as Single statement. Failed [3706 : 42000] Syntax error: expected something between the word 'DecryptByKey' and '('.
Elapsed time = 00:00:00.012
I would appreciate your help
The likely problem is that the function DecryptByKey() is not installed, or at least not in a database where it can be found. I am not aware of a Teradata version of this function; as far as I know it is specific to SQL Server.