Reserved words?

Posted in 1999

Hamilton, Jerry — Wed, 4 Aug 1999 14:27:47 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi Everyone, I'm running On-Line 7.23.UC6 on a HP 9000K. I have just installed Informix Dynamic Server 7.31.UC2 on a HP-9000D. Both machines are running HP-UX 10.20 and PeopleSoft Financials. The following simple query works fine using On-Line 7.23.UC6, but does not work using IDS 7.31.UC2: select type.item from "psoft7".ps_fh_ws_bl_inv_hs type where item ="1013780" When executed under 7.31 I get, "201: A syntax error has occurred". Has anyone run into something like this yet? "Type" does not appear on the Informix reserved words list. Jerry Hamilton Fleishman-Hillard St. Louis