RE: Reserved words?
Jerry,
There is a technical bulletin,
http://www.informix.com/informix/services/ilink/alerts/033199_n004.htm
Dated on March 31, 1999 that says:
Title
With the addition of the new functionality "nonlogged table" type to
Informix Dynamic Server' 7.31, TYPE is now a reserved word.
HTH
Tino
>
> 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
>