Replication Server supports replication of encrypted column data between Adaptive Server databases. However, replication of encrypted column data to any non-ASE replicate database is not supported.To replicate non-encrypted data to an ASE database containing an encrypted column, disable the rs_set_ciphertext function string for the Adaptive Server connection. The rs_set_ciphertext function string is executed for all ASE connections by default. It indicates to the replicate ASE database that the data to be replicated is already encrypted and the assumption is that the primary database is also an ASE with the same encryption usage. By disabling the rs_set_ciphertext function string, you allow the replicate ASE to perform encryption on the incoming replicated data. Allowing ASE to encrypt the incoming data is appropriate if the primary database is non-ASE, or if the primary ASE database does not use enrypted columns.
rs_set_ciphertext
Controls replication of encrypted columns to an Adaptive Server table.
Alter function string rs_set_ciphertext to turn off execution of the ASE-specific command “set ciphertext on.”
alter function string rs_set_ciphertext for some_function_string_class output language ''
