Re: Reserved words?

Posted in 1999

Dick Snoke — Wed, 04 Aug 1999 16:18:02 -0400 — source: Informix-list mailing list archive (1991-1998)

At 02:27 PM 08/04/1999, Hamilton, Jerry wrote: >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. "type" is added to the reserved word list via the release notes for IDS 7.31, dated January 1999. The change is part of the "non-logged tables" feature. Cheers, Dick > >Jerry Hamilton >Fleishman-Hillard >St. Louis > Dick Snoke dsnoke@informix.com Partner Engineering 770-395-2308 Informix Software 5 Concourse Parkway Suite 1500 Atlanta, Georgia 30328