decrypt_fpe_byteint()
Description
Given an encrypted string created using encrypt_fpe_byteint() and a profile name, returns its decrypted cleartext.
function decrypt_fpe_byteint (inputString varchar(8192) CHARACTER SET LATIN, inputKeyname varchar(256)) returns byteint
Example
The following example decrypts a byteint number. It is assumed that a profile has been set up in profiles.conf with the name tokenize_CC and the encryption method fpe.
BTEQ -- Enter your SQL request or BTEQ command:
#select decrypt_fpe_byteint('207','tokenize_CC');
#select decrypt_fpe_byteint('207','tokenize_CC');
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
thales.decrypt_fpe_byteint('207','tokenize_CC')
-----------------------------------------------------------------------
120
