On Mon, 13 Sep 2004 23:58:38 -0400, Tom wrote:

As Jonathan suspects, the problem's not the database. I've tried all of your
versions on IDS 9.4 and 7.31 and they all work just fine. There's something
going on in your front-end.

Art S. Kagel

> Trying to do some very basic SQL on an Informix 7.x box. What I know works
> is this for either a telnet session or an ODBC connection.
>
> Select size from item
> Select size as bob from item
>
> What doesn't work is
>
> Select 0 as size from item
> Select 0 as 'size' from item
> Select 0 as "size" from item
>
> I didn't create the table using a reserved word as a column name I know size
> is a reserved word.
> I'm a contractor in a shop that appears to have very limited knowledge and
> no desire to share information.
> I know the putz who created the table is long gone. I am a MS-SQL Server/VB
> developer so I know enough SQL to be dangerous in an Informix environment.
> Per the Informix documentation and my experience, I should be able to
> surround a reserved word with some sort of delimiter to use it as a column
> name.
> While I can code around this issue at the client, it would be a heck of a
> lot easier to get the recordset returned to me with a column named as I need
> it.
> I know that there are a ton of people out there a lot smarter than I am.
>
> Any thoughts?