Follow-up to a response I made earlier - but it won't be properly threaded
in
the news groups (sorry)...

Tom <feelingcocky@hotmail.com> wrote:
> 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

This definitely works for me with DB-Access or SQLCMD and IDS 9.40.UC4
on Solaris 8.

> Select 0 as 'size' from item
> Select 0 as "size" from item

Somewhat to my surprise - my memory is clearly getting rusty - both of
these
generate -201 syntax error messages under normal circumstances. If you
set
DELIMIDENT, then the double-quoted version works fine.


--
Jonathan Leffler (jleffler@us.ibm.com)
STSM, Informix Database Engineering, IBM Data Management
4100 Bohannon Drive, Menlo Park, CA 94025
Tel: +1 650-926-6921 Tie-Line: 630-6921
"I don't suffer from insanity; I enjoy every minute of it!"

sending to informix-list