encrypt_smallint()
Description
Given a cleartext string in SMALLINT dataype format and a keyname, returns its encrypted equivalent.
function encrypt_smallint (inputdata smallint, inputKeyname varchar(256)) returns varbyte(16000)
Example
The following example encrypts a smallint number:
#select encrypt_smallint(32000,'ctp-key');
#select encrypt_smallint(32000,'ctp-key');
System Response
*** Query completed. One row found. One column returned.
*** Total elapsed time was 2 seconds.
thales.encrypt_smallint(32000,'ctp-key');
----------------------------------------------
E939997FBF75D6DCE47BBD1E1C1B69C7
