decrypt_byteint()
Description
Given an encrypted string created using encrypt_byteint() and a keyname, returns its decrypted cleartext.
function decrypt_byteint (inputString varbyte(16000), inputKeyname varchar(256)) returns byteint
Example
The following example decrypts a byteint number:
# BTEQ -- Enter your SQL request or BTEQ command:
#select decrypt_byteint('B66B4C6CB7F80416DD8FBA4A1211B5C4'xb,'ctp-key');
#select decrypt_byteint('B66B4C6CB7F80416DD8FBA4A1211B5C4'xb,'ctp-key');
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
thales.decrypt_byteint('B66B4C6CB7F80416DD8FBA4A1211B5C4'xb,'ctp-key');
---------------------------------------------------------------------------
120
