Re: Searching across three files

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

CREATE VIEW - the SELECT statement using UNIONs is what you put into the 
CREATE statement.

It's promptable in interactive SQL, IIRC - and if not, there's always 
the SQL Reference!

HTH
Vern

25 years of the Pipe Dreams programs on public radio!!! From right here 
in fly-over land! I've actually met Michael Barone, but he'd never know it!

James Lampert wrote:
> Thanks to both "sjl" and Roger Harman for reminding me of UNION. I was 
> having trouble remembering what the thing was called in SQL, as well as 
> whether it was even available under OS/400; on closer examination, I'd 
> been using it since I first began using SQL.
>
> But see my previous message about the $64 question: is there a way to 
> set up a persistent, dynamic UNION, that behaves like a file?
>
>