2

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.

Harikrishnan
  • 9,688
  • 11
  • 84
  • 127
toch
  • 67
  • 6
  • Good question. Take a look at `git grep --color -A 5 -B 5 INFORMIX_SE` in the sources. It looks like it affects `WITH HOLD` cursors and an error handling case. I haven't read into the details. – Craig Ringer Feb 17 '14 at 14:41

1 Answers1

2

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.

Joe R.
  • 2,032
  • 4
  • 36
  • 72
  • Thanks, the INFORMIX version I use is 7.24C9. Apparently, It should be a C-ISAM version : [see doc](http://www-01.ibm.com/software/support/lifecycleapp/PLCDetail.wss?synkey=A465583Y71672Y52&from=spf). Am I alright ? – toch Feb 19 '14 at 09:39
  • Hmm, no upvote for the answer? Correct, you're using SE. Is it running on a Solaris 8 system? – Joe R. Feb 24 '14 at 03:50
  • I cannot upvote (I need 15 reputation). No we are running on RHEL 5.2 – toch Feb 25 '14 at 09:14