Re: building sets in SQL92

That will work in DB2, but it is not part of SQL-92.

"Aakash Bordia" <a_bordia_at_hotmail.com> wrote in message news:9f8nt8$10ts$1_at_stlnews.stl.ibm.com...
> values('boston') union values('ny')
> will work
> Thanks
> Aakash
>
> "Sten Loecher" <sten-loecher_at_gmx.de> wrote in message
> news:9f5n16$7cv$1_at_kastor.inf.tu-dresden.de...
> > Hi folks,
> >
> > I need to write a query in SQL92 that builds a set "on the fly" for use
 as
> > kind of temporary table. For example, in Oracle SQL I could write:
> >
> > select 'Boston' as CITY from DUAL
> > union
> > select 'Atlanta' as CITY from DUAL
> > union
> > select 'Columbia' as CITY from DUAL
> >
> > with DUAL as a table that has one column and one row, because I must
> > specify some table.
> > The result of this query would be:
> >
> > CITY
> > ------
> > Boston
> > Atlanta
> > Columbia
> >
> > In SQL92 one can write this query too, which told me the according
 grammar.
> > The specification of a table is also mandatory.
> > What I'm thinking about is, wheter the semantic is supposed to return
 the
> > same result like in Oracle or wheter such a such a query is allowed at
 all.
> > Maybe there is still another way to build such a set in SQL92, isn't it
 ?
> >
> > Would appreciate any help.
> >
> > Sten
> >
> >
> >
> >
> >
>
>
Received on Sun Jul 22 2001 - 01:28:21 CEST