DataExchange Reserved Words and Table Names

DataExchange reserved words are keywords with special meanings when processed by the replication engine. These words cannot be used as database or table names in your applications. The following table lists the replication system table names used by DataExchange.

In addition to the system table names listed here, DataExchange creates a unique replication table for each user table in your database that you have marked for replication. Replication user tables created by DataExchange are named by prefixing PDC to the original file name for the table. For example, a file named Billing.mkd has a companion replication file named PDCBilling.mkd. DataExchange uses the PDCfilename convention to keep track of the files during replication.

In the event of tables with the same name in different folders, DataExchange creates a unique file name, similar to the naming convention used for log files. For example, two files named Billing.mkd located in different directories would result in files named PDCBilling.mkd and PDCBilling0.mkd.

DataExchange requires that the replication tables created from selected user tables have unique names. Zen limits table names to 20 characters. Replication table names created by DataExchange meet these requirements.

DataExchange conforms to almost all of the same limitations and conditions implied in Zen. The following lists any known DataExchange limitations that differ from those listed for the ODBC Engine Interface.

For the complete list of ODBC engine interface limitations, see the ODBC documentation.