decrypt_int()
Description
Given an encrypted string created using encrypt_int() and a keyname, returns its decrypted cleartext.
function decrypt_int (inputString varbyte(16000), inputKeyname varchar(256)) returns integer
Example
The following example decrypts a negative integer number:
# BTEQ -- Enter your SQL request or BTEQ command:
#select decrypt_int('6177A2C2E8D2491F48C01843136E88CB'xb,'ctp-key');
#select decrypt_int('6177A2C2E8D2491F48C01843136E88CB'xb,'ctp-key');
thales.decrypt_int('6177A2C2E8D2491F48C01843136E88CB'xb,'ctp-key');
------------------------------------------------------------------------
-90000
