decrypt_ff1()
Description
Given an encrypted string created using encrypt_ff1() and a profile name, returns its decrypted cleartext.
function decrypt_ff1 (inputString varchar(8192) CHARACTER SET UNICODE, inputKeyname varchar(256)) returns varchar(8192) CHARACTER SET UNICODE
Example
The following example decrypts a customer’s first and last name. It is assumed that a profile has been set up in profiles.conf with the name tokenize_name and the encryption method ff1.
BTEQ -- Enter your SQL request or BTEQ command:
# select thales.decrypt_ff1('OHBU cCj','tokenize_name');
# select thales.decrypt_ff1('OHBU cCj','tokenize_name');
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
thales.decrypt_ff1('OHBU cCj','tokenize_name')
-----------------------------------------------------------------------
John Doe
