Postgresql mode INFORMIX or INFORMIX_SE

436 Views Asked by At

In PostgreSQL, with ecpg, there are two compatibility modes: INFORMIX, INFORMIX_SE.

Is there a difference between INFORMIX setting mode and INFORMIX_SE setting mode? I do not see any detail about this Postgresql Doc

Thanks.

1

There are 1 best solutions below

3
On BEST ANSWER

INFORMIX refers to Informix Dynamic Server and INFORMIX_SE refers to Informix Standard Engine. So you must know what type of Informix DB your target is. SE uses C-ISAM, where INFORMIX uses RSAM. Visit the IBM Informix website for more info. This link also explains adaptability of PostgreSQL with both Informix DB models.