encrypt_ff1_byteint()

Description

Given a cleartext string in BTYTEINT datatype and a profile name, returns its encrypted equivalent.

If there are characters in the plaintext input that are not specified in the character set, they are left in their current positions unchanged in the tokenized output. If the plaintext input is less than 2 characters (not counting characters that are not specified in the character set), the output of the UDF is the same as the plaintext input. FF1 can tokenize only strings with 2 or more characters.

Example

The following example encrypts a byteint number. It is assumed that a profile has been set up in profiles.conf with the name tokenize_CC_FF1 and the encryption method ff1.

#select encrypt_ff1_byteint(120,'tokenize_CC_FF1');
#select encrypt_ff1_byteint(120,'tokenize_CC_FF1');
*** Query completed. One row found. One column returned.
*** Total elapsed time was 2 seconds.
thales.encrypt_ff1_byteint('120','tokenize_CC_FF1')
-------------------------------------------------------------------
577