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