Encrypt – Decrypt password in a translation map

Encrypt – Decrypt password in a translation map
- 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.