RE: LF on 2 files with 'UNION'

[<SRamanujan@xxxxxxxxxxxxxxxxxx>]

Thanks every one for your time!  I will wait for v5r2 to create my view.  
Meanwhile, will have to work the way it is now.

Sudha

-----Original Message-----
From: Vern Hamberg [mailto:vhamberg@centerfieldtechnology.com]
Sent: Wednesday, November 06, 2002 7:15 PM
To: midrange-l@midrange.com
Subject: RE: LF on 2 files with 'UNION'


CREATE VIEW with UNION is V5R2

Vern

At 06:55 PM 11/6/2002 -0600, you wrote:
>At 13:34 11/06/2002, Sudha Ramanujan wrote:
>>I did something like the following that errored out.
>>
>>  create view filevew  as
>>   select afield1,afield2,afield3 from filea
>>    union select bfileld1,bfield2,bfield3 from fileb
>
>
>Sudha,
>
>Try something like this:
>
>   create view filevew as
>     select afield1 field1,
>            afield2 field2,
>            afield3 field3
>     from filea
>     union select
>            bfield1 field1,
>            bfield2 field2,
>            bfield3 field3
>     from fileb
>
>
>Pete Hall
>pbhall@ameritech.net
>http://www.ameritech.net/users/pbhall/index.html


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.