Destination Column Names and Reserved Names

Because database systems vary on what they consider reserved names, one must be careful when replicating tables with columns that have names that are reserved names for the destination system, but not the source system. You may be able to handle this issue with quoted identifiers, or by editing the subscription and changing the name of the destination column.

An error such as:

[Informix][Informix ODBC Driver][Informix]DDL operations on "rowid" prohibited.

Or

ORA-00904: "ROWID": invalid character

may be the result of using a column name in the source system that happens to be a naming function on the destination system, and where the destination database does not support quoted identifiers to override the default naming. In the case of Informix or Oracle, one can use a different case for the destination column name to distinguish the name.