To encrypt a field in a translation map we can write the following code in extended rule:

string[255] password;

object ob;

ob = new("com.sterlingcommerce.security.opsutilities.DBPasswords");

password = ob.encrypt($COLL_FTP_password.#COLL_FTP_password);

To decrypt a field in a translation map, extended rule will be:

object ob;

ob = new("com.sterlingcommerce.security.opsutilities.DBPasswords");

#COLL_FTP_password = ob.decrypt(#COLL_FTP_password);

I found this function cannot be done on the output side when format is SQL, just on the input side or any extended rule level where it is possible to do, either on input field directly, or to take a field value into variable and run a mehtod (encrypt or decrypt) on variable.

About donation

As you all know I've been doing this for over a decade and have never asked for anything from anybody. I do not have any sponsors; and all the time and money I've invested over the years has been accumulating. Now I request, if you can, please show your appreciation to the site by making a small donation for servers and site maintenance.