| Product: | Syniti Data Replication, DBMoto |
| Version: | All |
| ID: | 3005 |
| Summary: | Issue updating columns with a Serial data type when replicating from Informix to Informix |
In mirroring from Informix to informix with a Serial data type column, you will get the following error message during an update operation because the SERIAL type stores a sequential integer, of the INT data type, which is automatically assigned by the database server when a new row is inserted.
IBM.Data.Informix.IfxException (0x80004005): ERROR [HY000] [Informix .NET provider][Informix]A SERIAL column ( ) may not be updated.
However, it is possible to insert a value in a Serial column, even if the update fails in replication. The workaround for update operations is to use the attached script to set the Serial column to "Nothing" so that Syniti DR/DBMoto does not update this column. See the attached sample script where "ID" is the name of the Serial column.