Re: [Fwd: SQL As statement w/ delimiter]

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