DecryptByKey

Database
N/A

DecryptByKey

Hi,

 

I want to convert this syntax from SQL SERVER to TERADATA:

 

convert(varchar(8000),DecryptByKey(A.LastName))

 

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

Thanks.

2 REPLIES
Teradata Employee

Re: DecryptByKey

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.

N/A

Re: DecryptByKey

Thank you