Re: IDS 7.30 on server and i4gl 6.04 on client

Posted in 1998

�yvind Gjerstad — 02 Sep 1998 10:05:17 +0200 — source: Informix-list mailing list archive (1991-1998)

ogj@tglobe3.tollpost.no ('yvind Gjerstad) writes: > We upgraded some of our servers from ODS 7.14 to IDS 7.30 this weekend. > We then discovered that one front-end running 4gl 6.04 (and esql/c 7.14) > had big troubles with some queries. When place-holders were used in > prepared statements in the 4gl or esql/c code, no indexes where used, > we got only sequential scans. OK. Now this is solved. The problem was that for some reason COLLCHAR was set to 1 on the client. Nobody knows why. Just unsetting this variable solved the case. We discovered it by an accident. Informix has reported it as a bug. -- 'yvind Gjerstad Systems dept Tollpost-Globe AS N-6301 'ndalsnes/Norway E-mail: ogj@it.tollpost.no Phone: +47 7122 6663 Fax: +47 7122 6694