Re: SQL Question
In reply to tolli's email about Re: SQL Question, on 4 Sep 97
Dump from Mail header :
From:tolli <tolli@work.right.now>
^^^^^^^^^^^^^^^
I see.
Reply-To: tolli <tolli@work.right.now>
^^^^^^^^^^^^^^^
No I won't.
Organization: Hardly
^^^^^^
Really.
Nice statistics those !!!
End dump from Mail header.
Sorry Informixers but could not resist. I know this could be flames but...
> Hi,
>
> I'm (just ?) an Oracle-user, but I wonder what great functions
> Informix has to offer:
>
> In the cursor you describe, you fetch a 'UNION' cursor into _two_
> fields !?!
>
You mean Oracle lets you select only one field at a time when using UNION.
The Informix syntax is
SELECT field1, field2...fieldn
INTO var1, var2...varn
FROM table1
UNION
SELECT fld1, fld2...fldn
FROM table2
etc.
> Has Informix got its own version of ANSI-SQL ???
>
> Greetings,
>
> Tolli
Hope this improves your Informix skills.
Ravi...
--
Ravi Joseph Pinto, mailto:ravi@in.dhl.com
Senior Consultant, voice :91-22-8503000
Astra Infotech, Mumbai, India extn. 1531
If Network is computer, how come Sun makes servers, not routers ;-)
PS : Standard disclaimers apply.