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
ft:locale
en-US
Product name
Connect CDC
ft:title
Connect CDC Getting Started Guide
Copyright
2025
First publish date
2003
ft:lastEdition
2026-02-25
ft:lastPublication
2026-02-25T19:01:02.274000
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Connect
L4_Investment_Segment
Application Data Integration
L5_Product_Group
ADI - Connect
L6_Product_Name
Connect CDC

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.