Search code examples
encryptiondatastagedata-masking

Encrypt function in datastage transformer


In DB2 SQL, there is a function Encrypt(). What is the equivalent function in Datastage transformer.

DB2 SQL:

Update Table_name set Column_Name = Encrypt(Column_Name) 

Solution

  • please create a parallel routine which takes input as the input column for this encryption as per requirement and call it in transformer column derivation or expression .

    OR

    try to push encryption/decryption logic while reading or writing database as per requirement/business logic

    OR

    if its related file operations then try external source stage where you can specify (example unix/dos commands) encryption or decryption logic as per logic