SQL exception from Informix target with user-defined datatype or list - Connect_CDC - connect_cdc_mimix_share - 6.x

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
6.x
Language
English
Product name
Connect CDC
Title
Connect CDC Getting Started Guide
Copyright
2024
First publish date
2003
Last updated
2024-10-15
Published on
2024-10-15T20:38:41.117981

If your model has an Informix DS target and a table has a user-defined datatype or a list, it may generate an error like the following:

[ChangeApplier13] ERROR:06413: Sql exception occurred: Error creating a statement:
ERROR DETAILS >>> [Error:-999] [State:IX000] Message: Not implemented yet.

Executing any SQL DML statement, such as select count(*), against the table will prevent this from happening. The statement must be executed in the context of the database in which the table resides; it is not sufficient to specify a fully qualified name from a different database.