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