SQL-Syntax with Informix ODBC 3.32

Posted in 2000

Reinhard Habichtsberg — Wed, 4 Oct 2000 15:21:27 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, we have to use following sql-statement: select auftrnr, case when auftrnr = 3000147 then 1 else 0 end as test from auftrag where auftrnr = 3000147 or auftrnr = 3000148 This works with SCO Vision ODBC driver. With Informix ODBC-Driver 3.3x we get the error message: Informix ODBC Driver: General error. Syntax error. Is there somebody who can say if it is possible to use "case" in select-statements with the Informix ODBC driver. TIA Reinhard