Returns the decrypted value in string format. Data Integration uses the Advanced Encryption Standard (AES) algorithm with the Electronic Codebook (ECB) mode of operation. The AES algorithm is a FIPS-approved cryptographic algorithm that uses 128-bit encryption.
Syntax
AES_DECRYPT ( value, key )
Argument
Required/
Optional
Description
value
Required
Binary datatype. Value you want to decrypt.
key
Required
String datatype. Precision of 16 characters or fewer. Use the same key to decrypt a value that you used to encrypt it.
Return Value
Decrypted string value.
NULL if the input value is a null value.
Example
The following example returns decrypted Social Security numbers. In this example, Data Integration derives the key from the first three numbers of the Social Security number using the SUBSRT function: