decrypt_data()
Description
Given an encrypted string created using encrypt_string() and the key used to encrypt data, returns its decrypted cleartext.
function decrypt_data (inputString varbyte(16400), inputKeyname varchar(256)) returns varchar (16384)
Note
decrypt_data() cannot be used to decrypt data that was created using encrypt_cbc(), encrypt_fpe(), or encrypt_ff1(). Use the corresponding decrypt_cbc(), decrypt_fpe(), or decrypt_ff1() functions instead.
Example
BTEQ -- Enter your SQL request or BTEQ command:
# select thales.decrypt_data('97E7BCEB7D8EA55A59BC83BD44609B0A'xb,'KEY1');
# select thales.decrypt_data('97E7BCEB7D8EA55A59BC83BD44609B0A'xb,'KEY1');
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
thales.decrypt_data('97E7BCEB7D8EA55A59BC83BD44609B0A'XB,'KEY1')
-----------------------------------------------------------------------
clear text
