FAQ: Why is Informix Dynamic Server 9.21 UC4/HC4 not supported with ArcSDE 8.3?
Why is Informix Dynamic Server 9.21 UC4/HC4 not supported with ArcSDE 8.3?
This is a known issue in Informix 9.21. The problem is that the parameterized view for the versioned table has all the columns defined as NULL even though se_area_shape_ column is NOT NULL in the base table and A-table. Then when the SDE client tries to load the data, it will first query the versioned table, in fact, the actual view for the versioned table, to determine the nullability of all the columns and get the feedback that all the columns are NULL. So it will insert NULL to se_area_shape_ column and violate the not null constraint on the se_area_shape_ column.
This view nullability issue has been fixed in Informix IDS 9.30 server.