Reserved Table Names

Reserved Table Names

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.

ActivateInfo	dActHist	dActSite
dActTbl	dCmd	dCmdSite
dCnf	dFKey	dFragF
dFragI	dGrp	dIDB
dIDBDef	dKey	dLang
dMsg	dMsgLang	dPKey
dPrm	dPrmGrp	dPrmTyp
dQueue	dSched	dSchema
dSet	dSFSite	dSite
dSiteExt	dSiteLnk	dSiteSet
dSort	dTblChg	dTrn
dUsr	dUsrGrp	dUsrPrf
dVer	dWSTS

PDC Replication Tables

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. PSQL limits table names to 20 characters. Replication table names created by DataExchange meet these requirements.

Note A database deployed for replication is allowed to include table names that start with PDC. However, if you add those tables to a replication template, DataExchange asks you to confirm that they are not files internal to the replication system.

Other Limitations

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

PSQL Feature	DataExchange Limit or Condition
Database tables	4,800 (per replication network)

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