encrypt_int()
Description
Given a cleartext string in INTEGER datatype format and a keyname, returns its encrypted equivalent.
function encrypt_int (inputString integer, inputKeyname varchar(256)) returns varbyte(1600)
Example
The following example encrypts a negative integer number:
# BTEQ -- Enter your SQL request or BTEQ command:?
# select encrypt_int(-90000,'ctp-key');
# select encrypt_int(-90000,'ctp-key');
System Response
*** Query completed. One row found. One column returned.
*** Total elapsed time was 2 seconds.
thales.encrypt_int(-90000,'ctp-key');
-------------------------------------------
6177A2C2E8D2491F48C01843136E88CB
