encrypt_char()
Description
Given a cleartext string in Latin characters, a key and column size returns its encrypted equivalent.
function encrypt_char (inputString varchar(16384), inputKeyname varchar(256), inputCharcolumnsize INTEGER) returns varbyte(16000)
Note
The initialization vector (IV) for encrypt_char() is taken from the file /etc/vormetric/vormetric_local_crypto_server.conf. A sample IV = 000102030405060708090A0B0C0D0E0F.
Example
CREATE SET TABLE THALES.testvar2 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(column1 INTEGER,
column2 CHAR(13)
);
BTEQ -- Enter your SQL request or BTEQ command:
select column1,thales.encrypt_char(column2, 'KEY-NEW' ,13) as enc_col2 from testvar2;
select column1,thales.encrypt_char(column2, 'KEY-NEW' ,13) as enc_col2 from testvar2;
*** Query completed. 3 rows found. 2 columns returned.
*** Total elapsed time was 1 second.
column1 enc_col2
----------- -----------------------------------------------------
3 FB8CAA2F658963C73233A59589633B22
1 4C69855E490704EFF93DFEED957201F3
2 5F252180E7F86AE27F7050E3CE514115
